Oracle ： How to drop database

最新推荐文章于 2025-09-22 09:52:47 发布

原创最新推荐文章于 2025-09-22 09:52:47 发布 · 139 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL #C #C++ #C#

数据库专栏收录该内容

35 篇文章

订阅专栏

本文详细记录了使用Oracle 10g进行数据库删除与重建的过程，包括设置环境变量、启动实例、独占挂载数据库、系统配置调整、创建新数据库文件等步骤。

字号：大大中中小小

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