CAN I RECOVER DELETED DATAFILE AND ITS TABLESPACE USING FLASHBACK DATABASE
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.............