Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FlashBack Query

SKYNIAZIFeb 11 2008 — edited Feb 11 2008
hello to every one
i am using oracle 10g. i have a table that contain records.before 3 days ago i had deleted records from table.
but now i am trying to recovers those rows so therefore i am using flashback query hence when i write a flashback query it show error ORA-01555 snap shot too old rollback segment no 4 same '_SySSMU4$ TOO SMALL

so kindly tell me right way to recover my deleted data

best regard
amk niazi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2008
Added on Feb 11 2008
1 comment
248 views