Skip to Main Content

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!

Need help with export, truncate and import partitions for schema

oraclemagicianMar 9 2006 — edited Jul 15 2008
I need to export a couple partions for our Oracle 10g Data Warehouse, truncate the partions and re-import the data using the exported file. How can I do this?
In summary here is what I need to do:


1) Export partition P_SUB_1 of table1
2) Export partition P_SUB2 of table2

3) Truncate P_SUB1 partition of table1
4) Truncate P_SUB2 partition of table2

5) Rebuild indexes on table1 and table2

6) Re-import data into each partition from export files.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Mar 9 2006
7 comments
4,357 views