oracle数据库数据表的简单备份和还原

备份表数据： create table emp as select * from scott.emp

还原表数据：insert into emp select * from scott.emp

 

生成批量测试数据

create table myTestTable as
select rownum as id,
to_char(sysdate + rownum/24/3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime,
trunc(dbms_random.value(0, 100)) as random_id,
dbms_random.string('x', 20) random_string
from dual
connect by level <= 100000;