contatti
contacts

oracle export empty tables

oracle : version 11.2 enterprise edition

The export utility (exp) skips empty tables (tables with no rows)
in oracle version 11.2.0.1
For example , a backup of schema SCHEMA1 will not save empty tables :
exp userid/password owner=SCHEMA1 file=...

Oracle 11.2 introduced the new feature "deferred segment creation"
which is available only in enterprise edition.
You can find information here
exp utility is affected by this feature.

You can use datapump export instead of exp utility
or you can set the initialization parameter:
deferred_segment_creation=false
in init.ora or spfile and restart the database.
exp utilty saves new tables with no rows but the problem still exists for old empty tables.
You can force the allocation of extents on old tables using the following command :
alter table tablename allocate extent ;

The issue is fixed with oracle version 11.2.0.2

simplesix