DBA Hub

📋Steps in this guide1/1

Flashback a table to point in time

ALTER TABLE DBACLASS.EMP ENABLE ROW MOVEMENT; FLASHBACK TABLE DBACLASS.EMP TO TIMESTAMP TO_TIMESTAMP('2017-01-10 09:00:00', `YYYY-MM-DD HH24:MI:SS');

oracle configurationintermediate
by OracleDba
13 views
1

Flashback a table to point in time

Code/Command (click line numbers to comment):

1
2
3
ALTER TABLE DBACLASS.EMP ENABLE ROW MOVEMENT;
FLASHBACK TABLE DBACLASS.EMP TO TIMESTAMP
TO_TIMESTAMP('2017-01-10 09:00:00', `YYYY-MM-DD HH24:MI:SS');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!