Two days before i updated rows in a table and commited .But I want original status of my updated table is it possible ... if so ..help me with a query.
Printable View
Two days before i updated rows in a table and commited .But I want original status of my updated table is it possible ... if so ..help me with a query.
What is the verison of oracle that you are using ?
I am using Oracle 10g
Try using flashback queries using SCN.
I used following set to get original table,but table status is not changed.
select Dbms_flashback.get_system_change_number from dual
Alter table emp enable row movement
flashback table emp to scn(6082173321)
pls solve it
try the following sample code
[code]
select * from dept as of timestamp (sysdate-2)
[/code]
also try this for more specific time
[code]
SELECT * FROM emp AS OF TIMESTAMP TO_TIMESTAMP('2007-10-18 17:27:12', 'YYYY-MM-DD HH24:MI:SS');
[/code]
select * from emp as of timestamp (sysdate-2) By using this an error occur
i.e., ORA-01555: snapshot too old: rollback segment number 22 with name "_SYSSMU22$" too small
That is because your rollback segment is too small so the transaction details is deleted from there also .Now you can't use the specified command.