Need help with export, truncate and import partitions for schema
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.