配置实验环境:
1.1 生产三个文件
exp woo/oracle table=dump_table file=1.dmp;
expdp woo/oracle tables=dump_table directory=dhome dumpfile=2.dmp;
touch 3.dmp
2.创建随机数据
SQL> create table dump_table as
2 select rownum as id,
3 to_char(sysdate + rownum / 24 / 3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime,
4 trunc(dbms_random.value(0, 100)) as random_id,
5 dbms_random.string('x', 20) random_string
6 from dual
7 connect by level <= 10;
Table created.
SQL> desc dump_table;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
INC_DATETIME