网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的范文:

 

标题 如何不使用DBCA在Oracle 11中删除数据库
范文
    如何不使用DBCA在Oracle 11中删除数据库
    名单
    1- 导入数据库的SID,如果没有定义的话
    export ORACLE_SID=database
    2- 以操作系统认证连接数据库
    [oracle@Oracle11 ~]$ sqlplus / as sysdba
    SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014
    Copyright (c) 1982, 2009, Oracle. All rights reserved.
    Connected to an idle instance.
    3- 启动数据库实例
    SQL> startup
    ORACLE instance started.
    Total System Global Area 3340451840 bytes
    Fixed Size 2217952 bytes
    Variable Size 1828718624 bytes
    Database Buffers 1493172224 bytes
    Redo Buffers 16343040 bytes
    Database mounted.
    Database opened.
    4- 关闭数据库
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    5- 启动独占模式
    SQL> startup mount exclusive restrict
    ORACLE instance started.
    Total System Global Area 3340451840 bytes
    Fixed Size 2217952 bytes
    Variable Size 1828718624 bytes
    Database Buffers 1493172224 bytes
    Redo Buffers 16343040 bytes
    Database mounted.
    6- 删除数据库
    SQL> drop database;
    <br>Database dropped.
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
随便看

 

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。

 

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间:2025/5/24 16:30:26