Oracle2008/12/17 20:04

drop database in Oracle

 
Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement drop database.
The command gets rid of datafiles online redo log files, controlfiles and spfile.
Shaikh Ismail sent me an example on how to use the command. Thank you very much! Here it is: 
shutdown abort;
startup mount exclusive restrict; 
drop database;
exit

Requirements

  • database must be closed,
  • exclusively mounted,
  • restricted
출처 : http://www.adp-gmbh.ch/ora/sql/drop_database.html
크리에이티브 커먼즈 라이선스
Creative Commons License

'Oracle' 카테고리의 다른 글

isqlplus / em 접속  (0) 2008/12/21
[펌] print_table 프로시져 만들기  (0) 2008/12/18
drop database in Oracle  (0) 2008/12/17
sysdba 암호묻게 하는 방법  (0) 2008/11/10
클라이언트에 서버 추가  (0) 2008/10/24
실습 테이블 만들기(데이터 5백만건)  (0) 2008/10/22
Posted by 청짱
TAG
Trackback 0 Comment 0

TRACKBACK http://soseem.net/trackback/204 관련글 쓰기

댓글을 달아 주세요