oracle的imp导入数据,oracle imp 导入数据

首先，从一个用户下导出数据：

exp 'sys/sys@orcl as sysdba' file=d:/tmp.dmp tables=(tmpuser.TB1,tmpuser.TBs)

然后将导出的数据导入另一个用户tmpuser2：

C:\Documents and Settings\Administrator>imp 'sys/sys@orcl as sysdba' file=d:/tmp.dmp fromuser=tmpuser touser=tmpuser2

DECLARE   V_COUNT NUMBER; BEGIN   FOR I IN (SELECT TABLE_NAME FROM USER_TABLES) LOOP     EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || I.TABLE_NAME       INTO V_COUNT;     IF V_COUNT = 0 THEN       EXECUTE IMMEDIATE 'ALTER TABLE ' || I.TABLE_NAME ||                         ' ALLOCATE EXTENT';     END IF;   END LOOP; END; /