To archive history, you need to take the history partition and move the data out of the database into a file.
To archive history:
Note: The commands below represent the first history partition.
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;
/
create table r1_p1 as select * from staruser.w_activity_history_f where 0=1;
alter table staruser.w_activity_history_f exchange subpartition r1_p1 with table r1_p1;
drop table r1_p1;
staretl.bat "-from 31 -to 31"
./staretl.sh -from 31 -to 31
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014