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

Thread: Dropping a database

  1. #1
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    I have created a test Oracle 8.1.6 database on Sun Solaris 7. How can I completely drop the database to create a new production database afresh?
    Agasimani
    OCP(10g/9i/8i/8)

  2. #2
    Join Date
    Feb 2001
    Posts
    163
    If you have the database assistant, you can do it graphically. Or else stop the databae and remove all files related to the database.

    uday

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you are not going to use the dbassist, then make sure that you make the changes in the orainstall/orainvetory files or if database is the only installation that you have then just remove the orainstall/orainventory, the reason is that when you do the installation next time, installer would look into the inventory and decide that you have already installed the database.

    Good luck
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Even if you use "dbassist" still you need to do some clean up of OFA file structures/folders and oratab entry etc.,

    I meant total clean up of the database. Even if you don't not gonna hurt anything on the box.
    Reddy,Sam

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