开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜