Oracle Database Notes
Thursday 5 December 2013
Drop Oracle database with DBCA and Command Line
Drop Oracle database with DBCA
We can use dbca to drop the database.
Use DBCA GUI
Select
NO
.
The database is being drop. The password file and parameter file are being removed too. ( Both files are under $ORACLE_HOME/dbs).
sqlplus / as sysdba
Use DBCA Command line
dbca -silent -deleteDatabase -sourceDB oracledb1 -sysDBAUserName sys -sysDBAPassword
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment