How can I drop a datafile in NOARCHIVELOG mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How can I drop a datafile in NOARCHIVELOG mode

  1. #1
    Join Date
    Feb 2001
    Posts
    22
    Hi there,

    I want to drop 2 extra datafiles that just added to a tablespace.

    I used 'ALTER DATABASE DATAFILE OFFLINE DROP';

    When I restart the database, V$DATAFILE status became RECOVER. However, I can startup the database properly.

    How can I remove the datafile permanently in V$DATAFILE?





  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

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