Advice: Export Tables - SQL Inserts with tablespaces without storage

[Bert Gombos]

Hi All,

I use this tool frequently.
When 'include storage' option is checked it would be useful a new option to customize using of segment_attributes_clause's parts.

For example:
- to include TABLESPACE but no others.
- to include TABLESPACE and physical attributes ("PCTFREE ... INITRANS..." etc.) but no storage clause.
- to include TABLESPACE, physical attributes ("PCTFREE ... INITRANS..." etc.) and storage clause ("STORAGE (INITIAL ... NEXT ... etc )").

The second one is often used when I would like to export table structure to another database for developing purposes based on production database. In this situation TABLESPACE is important but storage clause causes large initial segment allocation.

Thanks.

Bert Gombos

 

[Marco Kalter]

I have added this to the list of enhancement requests.