D:\>set oracle_sid=fodder > > D:\>sqlplus /nolog > > SQL*Plus: Release 10.1.0.3.0 - Production on Fri Feb 18 20:15:26 2005 > > Copyright (c) 1982, 2004, Oracle. All rights reserved. > > SQL> connect / as sysdba > Connected to an idle instance. > SQL> shutdown abort; > ORACLE instance shut down. > SQL> startup nomount; > ORACLE instance started. > > Total System Global Area 612368384 bytes > Fixed Size 790352 bytes > Variable Size 174321840 bytes > Database Buffers 436207616 bytes > Redo Buffers 1048576 bytes > > SQL> alter database mount exclusive; > > Database altered. > > SQL> alter system enable restricted session; > > System altered. > > SQL> drop database; > > Database dropped. > > Disconnected from Oracle Database 10g Release 10.1.0.3.0 - Production > SQL> quit create new database file using OMF SQL> conn / as sysdba SQL> startup nomount; SQL> alter system set db_create_file_dest='D:\oracle\product\10.0.2.0\oradata\newdb\'; SQL> create database; SQL> alter database open; OK
Oracle : How to drop database
最新推荐文章于 2024-03-17 09:45:14 发布