HOW TO REMOVE deleted datafile entry

[mun93]

hi all,
I created a datafile on tablespace.
Then ,one of my deleted it. fortunately ,it was not containing any data.
But while taking backup i still find the entry of this datafile in
view v$datafile(backup script generates list of files to be backed up dynamically)
i want to remove this entry as i donot need to backup this file (and in backup it gives error)

i tried following script


>select name, status,enabled from V$DATAFILE;
>alter database rename file 'old' to 'new';
>alter database datafile 'new' offline drop;

shutdown;
start again

still i find the entry of the datafile

thanks for any help.

umesh
mun93@rediffmail.com

[oravijay]

Hi,

Even if you drop a datafile and restart the database/server, Oracle will still maintain the entry in the data dictionary views. If you want to remove it then drop the tablespace, create a new one.

Vijay.

[ac]

You also need to delete the datafile directory using O/S command - of course after dropping the tablespace as adviced by Viyjay.

AC

[oravijay]

Hi,

If you are using Oracle9i, it takes care of deleting the files from the OS.

Vijay.