Oracle Drop database

SQL> select instance_name from v$instance;

INSTANCE_NAME
—————-
wmsdev

SQL> shutdown immediate;
Database closed.
Database dismounted.
orACLE instance shut down.

SQL> startup mount exclusive
orACLE instance started.

Total System Global Area  939524096 bytes
Fixed Size                   781984 bytes
Variable Size             245633376 bytes
Database Buffers          692060160 bytes
Redo Buffers                1048576 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

======================
Notes:
Pls verify your instance name before drop database if there are more than one database on your server.

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>