| How we recover the data after enable the flashback [message #56913] |
Mon, 05 May 2003 22:58 |
saif ali sabri
Messages: 20
Registered: September 2002
|
Junior Member |
|
|
We do the following
Connect system/manager
Create table info (name varchar2(22), 10 number);
Insert into info values (‘ABC’, 1);
Insert into info values (‘DEF’, 2);
COMMIT;
Select * from info;
ABC 1
DEF 2
Now we check scn number 1015701
We delete some record
Delete info where name ‘ABC’;
Commit;
Now I enable flashback mode this number 1015701
We execute command
Select * from info;
ABC 1
DEF 2
Now I how reover data
Please tell me complete configuration
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
