Skip to Main Content

Java Database Connectivity (JDBC)

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!

Oracle sql - all records deleted and cannot retrieve data

User_PBFCFJan 3 2023 — edited Jul 13 2023

All records from all of my tables were removed from database. I didn't use any DELETE method to clear the database. Have you got any idea what could happen? I have never had similar situation before. I tried to retrieve data by following command:
select * from matches as of timestamp systimestamp - interval '24' hour;
but I get error: 01555. 00000 - "snapshot too old: rollback segment number %s with name "%s" too small"
I only add/update records and have no idea how to retrieve data from my tables.
Can someone guide me? Thanks a lot

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2023
Added on Jan 3 2023
3 comments
3,539 views