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

Thread: how to delete a DATABASE from command prompt ?

Threaded View

  1. 01-15-2003, 04:27 PM #4
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    1. Note the datafiles that make up this database

    select name from v$datafile

    2. Note the Control files

    select name from v$controlfile

    3. Shutdown the database and listener

    4. Remove the files noted above

    5. Remove this SID entry from
    /etc/oratab

    6. Remove this SID entry from
    $ORACLE_HOME/network/admin/listener.ora
    and
    $ORACLE_HOME/network/admin/tnsnames.ora

    7. Change your $ORACLE_SID env var

    8. If you want to remove the oracle software, let us know... That's got tentacles.

    9. Put your head between your legs and kiss your butt goodbye!
    Last edited by KenEwald; 01-15-2003 at 04:30 PM.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width