-
!HI
Iam using Oracle 9i Database on winNT platform?
I accidently delete one datafile by using OS command when database is in shutdown .
Database IS in NO archivemode
and i have no backup (NOTHING)?
now i want recovery what i have do ?
I don't want that datafile it is not important for me?
Can i get the database back?
-
ALTER DATABASE DATAFILE ... OFFLINE DROP
or
DROP TABLESPACE ...
-
Hi;
is your datafile in the Windows-Trashcan?
Orca
-
first u drop ur datafile by using this command
ALTER DATABASE DTATAFILE .........................OFFLINE DROP
after that
start database in nomount stage
create datafile
and then
alter databse open
ALTER DATABASE DATAFILE .............................ONLINE
or
ALTER TABLESPACE ONLINE.