PL/SQL (MOSC)

MOSC Banner

Recover Drop Table

edited May 16, 2016 5:02AM in PL/SQL (MOSC) 3 commentsAnswered

Hi Masters,

I Incidentally drop UOM Conversion Table. But I Created again the table and I Insert Data from Clone Database.

But the data in Clone Database is out of date. I read that oracle provided flashback to recover drop table.

I try to select * from recyclebin but the table I drop is not exist.

But when I select from dba_recyclebin the table I drop exist. I try to select using object_name I got from dba_recyclebin  but it return error, the table not exists.

Please Help.

Much Thanks for your help.

Regards,

Dian

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center