To restore archived history to the database:
- 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;
/
- Import the table into the STARUSER database. If you are using Oracle Database, see the Data Pump documentation for your version of Oracle for details.
- Restore the archived table to the STARUSER database.
- 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;
- Remove the table by running this command:
drop table r1_p1;
- Enter one of the following commands to restore security by running the STARETL process:
- With Windows:
setup.bat 37 37
- With UNIX or Linux:
setup.sh -from 37 -to 37