DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DB files

Threaded View

  1. 07-13-2004, 04:38 AM #4
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    What i will do in this case is

    1.Recreate the user tablespace.If all the objects in the tablespace can be re-created (recent export is available, tables can be re-populated using scripts or through SQL*Loader)Then, offline drop the datafile, drop the tablespace with including contents option.

    2.Restore file from backup and do a media recovery.Then u can drop the tablespace as per the normal procedure.

    Another useful link is

    http://metalink.oracle.com/metalink/...atabase_id=NOT
    Last edited by akhadar; 07-13-2004 at 04:47 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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