Issue recovering data
Posted on 2013-01-25
I dropped one tablespace that contained a couple of tables.
drop tablespace TABLESPACE1 including contents and datafiles;
Before dropping the tables, I backed up database while it was mounted, using
Then I ran
ALTER DATABASE OPEN RESETLOGS;
Then I had to run
After that I logged in as my regular user and executed
SELECT TABLE_NAME FROM USER_TABLES;
and none of the tables from my dropped tablespace were retrieved. The tablespace itself also was not recovered.
What did I do wrong? Is there a way to recover my tablespace with all the tables in it?