Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export/Import Partition table data

529840Aug 24 2006 — edited Aug 24 2006

Hi, I need to Export data from a table which has partitions(multiple) using EXP utility. I wanted to export a specific partition in the table.

How would i pass the option while mentioning this, I mean there is option for tables(T) and Table partitions as (T:P).

And the exported .dmp file has to be imported in the Test DB which has a empty partition similar to Prod DB. Version i am using is Oracle 8i.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2006

Added on Aug 24 2006

#general-database-discussions

4 comments

457 views