HOW TO REMOVE deleted datafile entry
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: HOW TO REMOVE deleted datafile entry

  1. #1
    Join Date
    Jan 2001
    Posts
    2
    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

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    178
    You also need to delete the datafile directory using O/S command - of course after dropping the tablespace as adviced by Viyjay.

    AC

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    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
  •  



Click Here to Expand Forum to Full Width