DBMS_DATAPUMP and Network Link
From: Sanjay Mishra <sm7315734_at_gmail.com>
Date: Wed, 10 Jan 2024 12:33:47 -0500
Message-ID: <CAO5eMJ7wq8PnuNOZCHE6fPU6jCrFGAu1GKcdkyoGaAOqDq5_Mg_at_mail.gmail.com>
Could someone share the PL/SQL script for automating the archiving of specific Oracle table partitions from one database to another using a Database link? We want to create a procedure that can use DBMS_DATAPUMP with Network_Link to archive some old partitions from prod to Archival Database before dropping them from production.
Date: Wed, 10 Jan 2024 12:33:47 -0500
Message-ID: <CAO5eMJ7wq8PnuNOZCHE6fPU6jCrFGAu1GKcdkyoGaAOqDq5_Mg_at_mail.gmail.com>
Could someone share the PL/SQL script for automating the archiving of specific Oracle table partitions from one database to another using a Database link? We want to create a procedure that can use DBMS_DATAPUMP with Network_Link to archive some old partitions from prod to Archival Database before dropping them from production.
Regards
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 10 2024 - 18:33:47 CET