Export from active standby database
Hello experts,
Recently I have faced a scenario where I was told to migrate a ODIEXPORT job in active standby database .Internally job was using datapump API to create external table.Same method was not possible as active standby database stays in read only mode.As a solution I have done following
- Created a staging database
- Created a database link to active standby database
- Created a PL/SQL procedure to export specific sub-partition using dblink created in above step and retain all Job master table data
- execute to export all sub-partitions data
- Create a PL/SQL procedure in target db so that it can read metadata from staging database to get dump file name and assigned tablespace
Tagged:
1