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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,129 views