dbms_sqldiag ????sql????????
???????????? ???????[ 2013/11/13 14:34:28 ] ????????
???????????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
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11