可以看见directory目录多了很多东西:
[root@linux exp_dir]# ll 总计 248 -rw-r----- 1 oracle oinstall 196608 11-08 21:49 oratcb1_007D001B0001dpexp.dmp -rw-r--r-- 1 oracle oinstall 969 11-08 21:49 oratcb1_007D001B0001dpexp.log -rw-r--r-- 1 oracle oinstall 4563 11-08 21:48 oratcb1_007D001B0001dpexp.sql -rw-r--r-- 1 oracle oinstall 3773 11-08 21:49 oratcb1_007D001B0001dpimp.sql -rw-r--r-- 1 oracle oinstall 1763 11-08 21:49 oratcb1_007D001B0001main.xml -rw-r--r-- 1 oracle oinstall 239 11-08 21:48 oratcb1_007D001B0001ol.xml -rw-r--r-- 1 oracle oinstall 173 11-08 21:48 oratcb1_007D001B0001sql.xml -rw-r--r-- 1 oracle oinstall 388 11-08 21:49 oratcb1_007D001B0001ssimp.sql -rw-r--r-- 1 oracle oinstall 422 11-08 21:49 oratcb1_007D001B0001xplf.sql -rw-r--r-- 1 oracle oinstall 654 11-08 21:49 oratcb1_007D001B0001xplo.sql -rw-r--r-- 1 oracle oinstall 399 11-08 21:49 oratcb1_007D001B0001xpls.sql -rw-r--r-- 1 oracle oinstall 1891 11-08 21:49 oratcb1_007D001B0001xpl.txt -rw-r--r-- 1 oracle oinstall 2316 11-08 21:48 README.txt |
导入:
u2@ORCL> conn u1/u1 已连接。 u1@ORCL> exec dbms_sqldiag.import_sql_testcase(directory => 'EXP_DIR',filename => 'oratcb1_007D001B0001main.xml',importData => true); PL/SQL 过程已成功完成。 u1@ORCL> select count(*) from t 2 ; COUNT(*) ---------- 1 u1@ORCL> select * from t; A ---------- 1 u1@ORCL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- T TABLE |