Dropping references to a datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dropping references to a datafile

Hybrid View

  1. #1
    Join Date
    May 2000
    Location
    Huntsville, AL. USA
    Posts
    52
    I have an issue where an admin performed a 'create like' command against a datafile but did not specify a datafile name, and in realizing this they went into the contents of the disk and deleted the datafile. Now the issue is that Oracle still 'sees' the datafile due to the fact that it is in the data dictionary, but there is no physical file on the disk where Oracle thinks it is. We have the database open and were trying various things in DBA studio such as deleting it or renaming it, but so far have been unsuccessful. How do we go about removing this reference from Oracle? We performed an alter database datafile offline drop; but this did not remove it from view in DBA Studio. Oracle assigned the name to the datafile, and it is referenced in the V$datafile view, but running the offline drop command should have removed it from the control file, correct? Is there any means to rid myself of this reference in the data dictionary short of dropping and recreating the tablespace?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is the status of you database? Do you have a full backup? Is the database in the archive log mode?

    Please let us know?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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