oracel 数据库导出语句

 exp 用户名/密码@ip/orcl file=D:\11shuju\cms_%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp owner=用户

 

-----------------此语句的作用是导出oracel 11g的空表
declare
stmt varchar2(200);
begin
for tb in (select table_name from user_tables where segment_created = 'NO') loop
stmt := 'alter table ' || tb.table_name || ' allocate extent';
begin
execute immediate stmt;
exception
when others then
dbms_output.put_line(stmt);
end;
end loop;
end;