目的:
oracle从A机器数据迁移到B机器上
环境:
A机器:
Windows 2003 + Oracle Database 10g 10.2.0.1.0
B机器:
Windows 2003 + Oracle Database 10g 10.2.0.1.0
以sys用户登录,先查询出数据文件位置:
select * from dba_data_files;
一:建立表空间
CREATE SMALLFILE TABLESPACE "TS1"
DATAFILE 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/M1BI/TS101.DBF'
SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE SMALLFILE TABLESPACE "TS2"
DATAFILE 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/M1BI/TS201.DBF'
SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;