dropping a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: dropping a database

  1. #1
    Join Date
    Oct 2001
    Location
    Atlanta, GA
    Posts
    22
    Friends & Gurus:

    Is there a way to drop a database? I have 4 databases that I no longer need and want to drop them to free up some disk space. I have already taken backup of them just in case. The only way i know is to drop the tablespaces w/in the database, but ran into some problem. Unable to drop the 'system' and 'rbs' tablespace. Any help/advice would be much appreciated.

    John

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you shutdown the database, delete all control files, redo logs, archived logs, datafiles, init.ora, bdump, udump, cdump and bye bye
    edit orataba if you have an entry there as well

  3. #3
    Join Date
    Oct 2001
    Location
    Atlanta, GA
    Posts
    22
    Thank you Pando. It works like a charm.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    edit listener.ora as well, forgot heh

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