dropping data file

[mkonar]

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.

[mhaller]

You need to drop the tablespace associated with the datafile and then physically remove the file.

[aracnid]

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)

[jgmagnus]

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)

- Magnus