Oracle Database Discussions

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!

Recover a dropped table in 11g

edy12Jan 18 2017 — edited Jan 18 2017

Hi Folks,

I am trying to recover a table which got lost because the schema was dropped using cascade option. Before the user got dropped I took full database backup including archives.

I tried to restore and recover the users tablespace but still the table was not recovered.

Can someone guide me to recover my table?

I am using 11gr2 and OLE-5

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2017

Added on Jan 18 2017

#general-database-discussions

21 comments

5,700 views