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!

copy partitions to another database

RobeenAug 28 2018 — edited Sep 4 2018

Oracle Database 12.1.0

Red Hat Linux 7.4

Hi Team,

I have a production database called ARCHICOM. There is a table called MOBILE_DATA which is partitioned monthly using interval partitioning. My aim is to copy monthly partitioned data from ARCHICOM to our BI database server.

I have checked the tranportable method and it seems I need to make the tablespace for table MOBILE_DATA offline and copy datafiles, which will not be possible.

https://docs.oracle.com/database/121/SUTIL/GUID-A697AD50-B366-4989-AA40-151D7089E810.htm#SUTIL202

Is there any other methods I can use to copy the partition to the BI server?

Regards,

Joe

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2018

Added on Aug 28 2018

#general-database-discussions

18 comments

676 views