Help!! datafile question!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help!! datafile question!

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Exclamation Help!! datafile question!

    THE TEAM CREATED A DATAFILE IN THE WRONG TABLESPACE AND IMMEDIATELY
    TURNED THE DATAFILE OFFLINE
    THE ONLY PROBLEM NOW IS THAT THE SQL BACKTRACK BACKUP IS FAILING BECAUSE THE DATAFILE IS OFFLINE
    SHOULD THEY TURN THE DATAFILE BACK ON

    AND HOW CAN WE TELL IF THERE IS DATA IN THE DATAFILE??

    THANKS FOR YOUR HELP!!

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You have a couple of choices here.

    1. Bring the file online and resize it to very small size, assuming the file has not been used yet.

    2. do 'offline drop' on that file. You won't get the errors but the file entry will remain in dictionary unless you drop and recreate the tablespace.

    To check whether any extent exists in datafile you can query DBA_EXTENTS
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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