Export issue on 11g, can’t export tables with zero rows.

Traditional Oracle export/import had bug exporting tables with not allocated segments in 11g 11.2.0.1

Exporting a schema with tables those have zero rows gets error EXP-00011.

This is because 11g introduced “segmented_created” column in DBA_TABLES. if you see value “NO” for this, that means no segments were allocated. In this case, Export can’t export table in version 11.2.0.1. This has been fixed in 11.2.0.2.

For this version of oracle, either use Datapump or allocate an extent using following syntax.

select owner, table_name,segment_created from dba_tables where sgement_created = ‘NO’

alter table ; allocate extent.

Note that allocating extent takes up little more space in database. It allocates according to tablespace’s definition.

Read Full Post »