I have dropped a datafile by,
-- deleting the file physically.
-- alter database datafile 'e:\...\...\x.prd' offline drop.
now the database is working fine but v$datafile still lists the datafile.
how can i get this cleared.
dropping data file
You need to drop the tablespace associated with the datafile and then physically remove the file.
on next shutdown & start your datafile will bee tracered as missing (you can not remove from there "dba_data_files" - until you don't make drop and create tablespace)
Yeah, the order is important.
What I do:
1. Drop TableSpace
2. Delete Datafile from Server
3. Remove the user associated with that tablespace (normally I have 1 user/connection per Schema/Tablespace, may not be best thing to do tho)
Click Here to Expand Forum to Full Width