How to import a partitioned table into a table with a different number of partitions? (Oracle 10g)
I have an existing database with tables which each have 4 partitions (there are tables using both RANGE and HASH partitioning).
I need to import it into another database with a pre-create开发者_JAVA技巧d schema where the same tables will have 8 partitions.
How do I do this? Does this "just work" if I do a table-level import?
Yes. Use the IGNORE=Y
setting and have the table precreated in the target schema/database the way you want it physically organized. The main problem you can run into is if you don't have the same "coverage" in the target system -- if there aren't partitions/subpartitions that can hold all the data you're importing from the source.
It depends if the partition values are the same. If 4 of the partitions in the new table have the same partition values as the old table, then you can import into a table set up the same as the old table, then split the partitions as necessary to get your 8 new partitions.
If you are not too much concerned about performance, just treat the process as moving data from one table to another. The platform will take of the rest.
精彩评论