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

Thread: Delete a database

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi folks,

    Is there any command to delete the existing database.

    I know that it can be done using dbassist; but want to know how to do it manually

    regards
    sonia

  2. #2
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Hi,

    There is no command as such to delete the Database.
    Just delete all the files.
    Hope it helps.
    Take Care.

  3. #3
    Join Date
    Apr 2002
    Posts
    13
    Hi Sonia,

    How to delete existing oracle manually?

    Windows platform
    ------------------------
    1. Shutdown the instance and Stop all oracle services that r runnig presently.
    from control panel utility.
    2. Delete all those services through regedit.
    3. Delete the Oracle installed directory .

    Unix.
    ------

    1. Shutdown the database.
    2. Delete Oracle servoce files ( or file that will created while runing rninstaller from /etc )
    3. Remove oracle directory.


    Let me know ur views.

    Kutty


  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sonia

    If you want to delete the database then delete the following files

    shutdown the database

    a)Control files
    b)data files
    c)redolog files
    d)Initilisation file

    entry from the /var/opt/oratab file or equiv registy entries from NT...

    If you want to delete the oracle software .Then follow the steps mentioned by kutty.

    regards
    Hrishy

  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    After stopping Oracle services. You should use ORACLE installer to uninstall it. Then you should delete the files and the entries in the Registry.
    Thanks
    Kishore Kumar

  6. #6
    Join Date
    May 2002
    Posts
    2

    remove all files from

    select name from v$datafile
    union
    select name from v$controlfile
    union
    select member from v$logfile
    /


  7. #7
    Join Date
    Aug 2001
    Posts
    75
    Oracle provides a tool called database configuration assistant (DBCA), this gives you option to delete a database. It will also delete services and all files assocaited with database in Windows environment. In Unix environment the executable is called dbca and you can delete the database.

    Sanjay
    OCP 8i

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