Oracle中利用EXP/IMP工具实现数据迁移

　SQL> CONN SYSTEM/TEST@RAC1已连接。

　SQL> CREATE USER YANGTK IDENTIFIED BY YANGTK DEFAULT TABLESPACE NDMAIN;

　SQL> GRANT CONNECT, RESOURCE TO YANGTK;

　SQL> CONN YANGTK/YANGTK@RAC1已连接。

　SQL> CREATE TABLE T (ID NUMBER, NAME VARCHAR2(30));

　SQL> ALTER TABLE T ADD CONSTRAINT PK_T PRIMARY KEY (ID);

　SQL> INSERT INTO T SELECT ROWNUM, TABLE_NAME FROM ALL_TABLES;

　SQL> COMMIT;

　SQL> CREATE INDEX IND_T_NAME ON T (NAME) TABLESPACE NDMAIN;

　SQL> CREATE TABLE T1 (ID NUMBER PRIMARY KEY, FID NUMBER, NAME VARCHAR2(30));

　SQL> INSERT INTO T1 SELECT ROWNUM, MOD(ROWNUM, 43) + 1,

SYNONYM_NAME FROM ALL_SYNONYMS;

　SQL> COMMIT;

　SQL> ALTER TABLE T1 ADD CONSTRAINT FK_T1_FID 

FOREIGN KEY (FID) REFERENCES T(ID);

　SQL> CREATE INDEX IND_T1_FID ON T1(FID);