Monday, March 9, 2015

Flashback


ALTER TABLE matthiash ENABLE ROW MOVEMENT;

FLASHBACK TABLE matthiash TO TIMESTAMP TO_TIMESTAMP('2013-05-03 13:00:00', 'YYYY-MM-DD HH24:MI:SS');


select * from v$tablespace where FLASHBACK_ON='YES';


*******************************************************

also try this 

select count(*) from SIEBEL.S_CS_QUEST as of timestamp to_timestamp('30-MAY-2022 18:00:00', 'DD-MON-YYYY HH24:MI:SS');

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...