oracle清空数据，只导入表数据

清空数据

declare v_sql varchar2(2000);
CURSOR cur is
select table_name from user_tables order by table_name;
begin
for rows in cur loop
v_sql := 'TRUNCATE TABLE ' || rows.table_name;
dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
end;

 

 

只导入表数据

imp puser/p12345@study  file=F:\study.dmp ignore=y full=y;