Restoring Archived History

Previous TopicNext TopicContents

To restore archived history to the database:

  1. Drop security on the W_ACTIVITY_HISTORY_F by running this command:

    begin

    dbms_rls.drop_policy('STARUSER', 'W_ACTIVITY_HISTORY_F', 'W_ACTIVITY_HISTORY_F_P_POLICY');

    dbms_rls.drop_policy('STARUSER', 'W_ACTIVITY_HISTORY_F', 'W_ACTIVITY_HISTORY_F_PC_POLICY');

    commit;

    end;

    /

  2. Import the table into the STARUSER database. See http://docs.oracle.com/cd/E11882_01/server.112/e10819/expimp.htm for more information.
  3. Restore the archived table to the STARUSER database.
  4. Restore the partition by exchanging the archive table into the correct partition. To restore the partition run this command:

    alter table w_activity_history_f exchange subpartition r1_p1 with table r1_p1;

  5. Remove the table by running this command:

    drop table r1_p1;

  6. Restore security by running the staretl process for your operating system.

Related Topics

Archiving and Restoring History

Archiving History



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014