http://colcool.iteye.com/blog/1180985
oracle11g的新特性,数据条数是0时不分配segment,所以就不能被导出。
解决方法:
1插入一条数据(或者再删除),浪费时间,有时几百张表会累死的。
2创建数据库之前
使用代码:
- alter system set deferred_segment_creation=false;
- alter system set deferred_segment_creation=false;
alter system set deferred_segment_creation=false;
调整再建表
这两种方都不好
下面是终极方法:
先查询一下哪些表是空的:
- select table_name from user_tables where NUM_ROWS=0;
- select table_name from user_tables where NUM_ROWS=0;
select table_name from user_tables where NUM_ROWS=0;
下面我们通过select 来生成修改语句:
- select ‘alter table ’||table_name||‘ allocate extent;’ from user_tables where num_rows=0
- select ‘alter table ’||table_name||‘ allocate extent;’ from user_tables where num_rows=0
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0
然后就在结果窗口里面生成了下面那些东西:
- alter table E2USER_STATE allocate extent;
- alter table ENTERPRISE_E2USER allocate extent;
- alter table ENTERPRISE_INFO_TYPE allocate extent;
- alter table ENTERPRISE_MAPMARK allocate extent;
- alter table ENTERPRISE_NEEDTASK allocate extent;
- alter table ENTERPRISE_PICTURE allocate extent;
- alter table ENTERPRISE_REPORT allocate extent;
- alter table ENTERPRISE_REPORT_TYPE allocate extent;
- alter table ENTERPRISE_TEAM allocate extent;
- alter table FROMUSER_ADJUNCT_TARGET allocate extent;
- alter table FROMUSER_OFFER allocate extent;
- alter table NEEDTASK_TYPE allocate extent;
- alter table SYS_PRIVILEGE allocate extent;
- alter table SYS_RELEVANCE_RESOURCE allocate extent;
- alter table SYS_RELEVANCE_TARGET allocate extent;
- alter table SYS_RESOURCE_TYPE allocate extent;
- alter table TASK_FEEDBACK allocate extent;
- alter table TASK_MYTASKTYPE allocate extent;
- alter table TOUSER_MESSAGE allocate extent;
- alter table ABOUTUSER_POINT allocate extent;
- alter table ABOUTUSER_POINT_MARK allocate extent;
- alter table ABOUTUSER_QUERYKEY allocate extent;
- alter table ABOUTUSER_REPORT_HISTORY allocate extent;
- alter table DICT_COMMENT_TYPE allocate extent;
- alter table DICT_INDUSTRY_TYPE allocate extent;
- alter table DICT_POST allocate extent;
- alter table DICT_REGION allocate extent;
- alter table ENTERPRISE_COMMENT allocate extent;
- alter table ENTERPRISE_COMMENT_C allocate extent;
- alter table ENTERPRISE_INFO allocate extent;
- alter table ENTERPRISE_INFO_C allocate extent;
- alter table ENTERPRISE_INFO_STATE allocate extent;
- alter table CALENDAR_CREATETYPE allocate extent;
- alter table CALENDAR_MY allocate extent;
- alter table CALENDAR_TYPE allocate extent;
- alter table E2USER_STATE allocate extent;
- alter table ENTERPRISE_E2USER allocate extent;
- alter table ENTERPRISE_INFO_TYPE allocate extent;
- alter table ENTERPRISE_MAPMARK allocate extent;
- alter table ENTERPRISE_NEEDTASK allocate extent;
- alter table ENTERPRISE_PICTURE allocate extent;
- alter table ENTERPRISE_REPORT allocate extent;
- alter table ENTERPRISE_REPORT_TYPE allocate extent;
- alter table ENTERPRISE_TEAM allocate extent;
- alter table FROMUSER_ADJUNCT_TARGET allocate extent;
- alter table FROMUSER_OFFER allocate extent;
- alter table NEEDTASK_TYPE allocate extent;
- alter table SYS_PRIVILEGE allocate extent;
- alter table SYS_RELEVANCE_RESOURCE allocate extent;
- alter table SYS_RELEVANCE_TARGET allocate extent;
- alter table SYS_RESOURCE_TYPE allocate extent;
- alter table TASK_FEEDBACK allocate extent;
- alter table TASK_MYTASKTYPE allocate extent;
- alter table TOUSER_MESSAGE allocate extent;
- alter table ABOUTUSER_POINT allocate extent;
- alter table ABOUTUSER_POINT_MARK allocate extent;
- alter table ABOUTUSER_QUERYKEY allocate extent;
- alter table ABOUTUSER_REPORT_HISTORY allocate extent;
- alter table DICT_COMMENT_TYPE allocate extent;
- alter table DICT_INDUSTRY_TYPE allocate extent;
- alter table DICT_POST allocate extent;
- alter table DICT_REGION allocate extent;
- alter table ENTERPRISE_COMMENT allocate extent;
- alter table ENTERPRISE_COMMENT_C allocate extent;
- alter table ENTERPRISE_INFO allocate extent;
- alter table ENTERPRISE_INFO_C allocate extent;
- alter table ENTERPRISE_INFO_STATE allocate extent;
- alter table CALENDAR_CREATETYPE allocate extent;
- alter table CALENDAR_MY allocate extent;
- alter table CALENDAR_TYPE allocate extent;
alter table E2USER_STATE allocate extent;
alter table ENTERPRISE_E2USER allocate extent;
alter table ENTERPRISE_INFO_TYPE allocate extent;
alter table ENTERPRISE_MAPMARK allocate extent;
alter table ENTERPRISE_NEEDTASK allocate extent;
alter table ENTERPRISE_PICTURE allocate extent;
alter table ENTERPRISE_REPORT allocate extent;
alter table ENTERPRISE_REPORT_TYPE allocate extent;
alter table ENTERPRISE_TEAM allocate extent;
alter table FROMUSER_ADJUNCT_TARGET allocate extent;
alter table FROMUSER_OFFER allocate extent;
alter table NEEDTASK_TYPE allocate extent;
alter table SYS_PRIVILEGE allocate extent;
alter table SYS_RELEVANCE_RESOURCE allocate extent;
alter table SYS_RELEVANCE_TARGET allocate extent;
alter table SYS_RESOURCE_TYPE allocate extent;
alter table TASK_FEEDBACK allocate extent;
alter table TASK_MYTASKTYPE allocate extent;
alter table TOUSER_MESSAGE allocate extent;
alter table ABOUTUSER_POINT allocate extent;
alter table ABOUTUSER_POINT_MARK allocate extent;
alter table ABOUTUSER_QUERYKEY allocate extent;
alter table ABOUTUSER_REPORT_HISTORY allocate extent;
alter table DICT_COMMENT_TYPE allocate extent;
alter table DICT_INDUSTRY_TYPE allocate extent;
alter table DICT_POST allocate extent;
alter table DICT_REGION allocate extent;
alter table ENTERPRISE_COMMENT allocate extent;
alter table ENTERPRISE_COMMENT_C allocate extent;
alter table ENTERPRISE_INFO allocate extent;
alter table ENTERPRISE_INFO_C allocate extent;
alter table ENTERPRISE_INFO_STATE allocate extent;
alter table CALENDAR_CREATETYPE allocate extent;
alter table CALENDAR_MY allocate extent;
alter table CALENDAR_TYPE allocate extent;
ok 执行上面那些sql,之后再exp吧,那就是见证奇迹的时刻。