Changing the session time in back
–step 1
select * from REGION_ANI;
begin
dbms_flashback.enable_at_time(to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’));
end;
–step 2
select * from REGION_ANI;
–step 3
begin
dbms_flashback.disable;
end;
–run below commands from sys user
–grant execute on dbms_flashback to claims;
–create synonym claims.dbms_flashback for dbms_flashback;
The syntax for enabling flashback query will accept either a timestamp or an SCN.
If you use an SCN, then the point to which the flashback goes is precise. If you specify
a time, it will be mapped onto an SCN with a precision of three seconds.
You can query the database as of an earlier point in time, but you
can never execute DML against the older versions of the data.
8 thoughts on “FLASHBACK SESSION”
buy amoxil 250mg without prescription cheap amoxil without prescription ivermectin 6 mg online
order alendronate 35mg without prescription order nitrofurantoin 100mg generic ibuprofen without prescription
order requip 2mg online cheap order ropinirole 1mg generic order trandate 100 mg online
cheap esomeprazole 20mg order furosemide sale order lasix pill
order generic tadalafil 5mg Free cialis cheap sildenafil sale
cialis online canada buy ed medication the blue pill ed
buy accutane 40mg online deltasone 5mg without prescription cost ampicillin 500mg
cheap prednisolone pills buy neurontin 600mg lasix ca