exp忽略没有分配段的表

为什么80%的码农都做不了架构师？>>>   

11.2，Oracle引入了段延迟创建，也就是创建了表，但是没有分配segment。

对这种没有分配segment的表进行exp操作时，表会被忽略，不在导出的list中。

In Oracle Database 11g release 2 (11.2), the DEFERRED_SEGMENT_CREATION parameter is set to TRUE by default. This means that any tables you create do not have any segments until the first row of data is inserted into the table. Original Export ignores tables without segments. Therefore, if you create any new tables and do not insert any data before performing an export, those tables are not exported. (Note that Data Pump Export does not have this limitation because it does not ignore tables without segments.)

转载于:https://my.oschina.net/huayd/blog/141745