oracel 数据库导出语句

最新推荐文章于 2021-04-02 22:14:53 发布

weixin_30389003

最新推荐文章于 2021-04-02 22:14:53 发布

阅读量116

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/auldlangsynezh/p/8136235.html

版权

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;

转载于:https://www.cnblogs.com/auldlangsynezh/p/8136235.html