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

Thread: Deleting UNDOTBS

Threaded View

  1. #21
    Join Date
    Jul 2005
    Posts
    10
    Hi Ken,

    I know restarting and checking the DB is not necessary and those steps should be be skipped by a DBA. But looking at the Oracle DB behaviour and DB administration being not my area of expertise I would like to ensure that after doing some major modification the DB opens properly.

    Secondly, oracle 9i doesnot delete the physical datafiles in windows.


    Well lets get back to the problem. Can anyone tell me - how to drop an undo
    tablespace if there is some active rollback segments in it
    Last edited by TomNJerry; 07-04-2005 at 12:10 AM.

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