| Datafile Dropping [message #57518] |
Fri, 20 June 2003 02:48  |
Moumita Dhar
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
|
While dropping a tablespace which is in online mode whose datafiles have already been removed an error message is coming that it .dbf file does not exist. How to proceed.
|
|
|
|
| Re: Datafile Dropping [message #57524 is a reply to message #57518] |
Fri, 20 June 2003 05:53  |
Velu Natarajan
Messages: 16
Registered: July 2002
|
Junior Member |
|
|
your not suppose to delete the datafile before droping the tablespace. only way to get back your database is to shutdown it and startup in mount stage. now create a datafile physically by using OS. and follow up the steps below.
Step 1:
Create physical datafile ('c:oracleoradatauser01.dbf')in the respective location by using os commend.
Step 2:
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database create datafile 'c:oracleoradatauser01.dbf' as 'c:oracleoradatauser01.dbf';
SQL> alter database open;
In this case all your data stored in datafile user01.dbf is lost. if you run your database in archivelog mode then it is possible to recover the database to its orginal status.
use
SQL> recover datafile 'c:oracleoradatauser01.dbf'
SQL> alter database open;
Good Luck...
Velu N
|
|
|
|
| Re: Datafile Dropping [message #57533 is a reply to message #57518] |
Fri, 20 June 2003 10:12 |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
There is an option with either the alter database or alter system command that will allow you to drop the tablespace. I know it is possible I don't recall the exact syntax. Check the manual.
tommy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
