| Removing entry of a datafile from controlfile [message #53090] |
Tue, 27 August 2002 23:35  |
venkatakrishnan
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
Hai everybody
I have a doubt.Please clear this.In my tablespace, I have two datafiles.One of the datafile is
corrupted
and i have no backup for that.I want to remove that data file from database.I make offline drop,still
it is existing while querying thro v$datafile.How to remove the entry from control file
dynamically(Assume that it is not possible to shutdown the db and recreate the control
file.Thanks.
|
|
|
|
| Re: Removing entry of a datafile from controlfile [message #53100 is a reply to message #53090] |
Wed, 28 August 2002 05:36  |
SKS
Messages: 26
Registered: February 2002
|
Junior Member |
|
|
select name from v$datafile where file#=2
(It gives the db file name)
alter database create datafile xyz.db (db file name in previous step)
recover database
alter database open
drop the tablespace which includes the missing file, all the file in the tablespace will be dropped!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
