Skip to Main Content

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!

CAN I RECOVER DELETED DATAFILE AND ITS TABLESPACE USING FLASHBACK DATABASE

Muhammad.UsmanJul 27 2009 — edited Apr 19 2012
HI!

I CREATED TABLESPACE WITH ITS DATAFILE.

SQL>create smallfile tablespace usmantbs datafile 'E:\oracle\product\10.2.0\oradata\orcl\usman.dbf' size 10M logging extent management local segment space management auto;

THEN I CREATED A USER AND ASSIGN THIS TABLESPACE TO HIM.

sql>create user usmanali profile default identified by usmanali default tablespace usmantbs account unlock;
sql>grant connect,resource to usmanali;

I CONNECTED WITH usmanali as USER AND CREATED A TABLE.

sql>conn usmanali/usmanali
sql>create table baseball(id number(9));

sql>select current_scn from v$database;

CURRENT_SCN
---------------------
545863

Next i deleted the tablespace including contents and datafiles.....

sql>drop tablespace usmantbs including contents and datafiles;

i dont have any backup of this datafile but my database is in archive log....

so can i .....flashback database to scn 545863 as it was before drop.....to get back my datafile along its tablespace
wil i get my datafile back or not? please help.............
This post has been answered by Kamran Agayev A. on Jul 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2012
Added on Jul 27 2009
8 comments
6,685 views