-
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
-
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.
Say No To Plastics
-
You also need to delete the datafile directory using O/S command - of course after dropping the tablespace as adviced by Viyjay.
AC
-
Hi,
If you are using Oracle9i, it takes care of deleting the files from the OS.
Vijay.
Say No To Plastics
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|