could you post command to drop a database in oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: could you post command to drop a database in oracle

  1. #1
    Join Date
    Mar 2013
    Posts
    1

    could you post command to drop a database in oracle

    thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Do you use ASM, or files on disk? If you use ASM then:

    Code:
    rman
    connect target /;
    
    shutdown abort;
    startup mount restrict;
    drop database;
    exit
    or

    Code:
    sqlplus '/as sysdba'
    
    show parameter dump
    show parameter diag
    
    select file_name from dba_data_files
    union all
    select file_name from dba_temp_files
    order by 1;
    
    shutdown abort;
    
    exit
    Then go and delete all of the directories with datafiles, then delete all of the dump directories
    and if this is 11g delete the directories with the sid name under diag/rdbms.

    You should make sure you are deleting the right database first.
    this space intentionally left blank

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