DROP DATABASE ORA-01504
来源:互联网 发布:联合办公网络设计方案 编辑:程序博客网 时间:2024/05/29 18:17
oracle 11g for win2008dc,drop database.
C:\Users\Administrator>set nls_lang=AMERICAN_AMERICA.ZHS16GBK
C:\Users\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 8 08:36:45 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount restiricted;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2262048 bytes
Variable Size 2650803168 bytes
Database Buffers 1610612736 bytes
Redo Buffers 12103680 bytes
ORA-01504: database name 'RESTIRICTED' does not match parameter db_name 'ORCL'
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount restrict;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2262048 bytes
Variable Size 2650803168 bytes
Database Buffers 1610612736 bytes
Redo Buffers 12103680 bytes
SQL> alter database mount;
Database altered.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
C:\Users\Administrator>
-EOF-
C:\Users\Administrator>set nls_lang=AMERICAN_AMERICA.ZHS16GBK
C:\Users\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 8 08:36:45 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount restiricted;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2262048 bytes
Variable Size 2650803168 bytes
Database Buffers 1610612736 bytes
Redo Buffers 12103680 bytes
ORA-01504: database name 'RESTIRICTED' does not match parameter db_name 'ORCL'
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount restrict;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2262048 bytes
Variable Size 2650803168 bytes
Database Buffers 1610612736 bytes
Redo Buffers 12103680 bytes
SQL> alter database mount;
Database altered.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
C:\Users\Administrator>
-EOF-
- DROP DATABASE ORA-01504
- drop database
- drop database
- Cannot drop a database link after changing the global_name ORA-02024 [ID 382994.1]
- drop database 删除数据库
- oracle Drop Database
- linux 下drop database
- drop tablespace ORA-02429
- 使用drop database删除数据库
- 手工删除数据库 drop database
- drop a database
- drop a database
- drop diskgroup报ora-15001
- ORA-00313: drop standby logfile
- DROP COLUMN ORA-12991 & ORA-12983
- drop user error ORA-00604 ORA-01418
- drop user error ORA-00604 ORA-01418
- alter database drop datafile 与 drop tablespace file 的区别
- 简化函数调用之六 :Replace Parameter with Explicit Methods(以明确函数取代参数)
- hdu 1305 Immediate Decodability
- Android入门:调用WebService
- 什么是面向对象(1)
- pb使用msxml进行网页存取
- DROP DATABASE ORA-01504
- JAVA形参值传递,引用传递分析。
- 生成 guid 字符串化
- 简化函数调用之七 :Preserve Whole Object(保持对象完整)
- UIColor使用colorWithRed定义颜色
- 0032算法笔记——【回溯法】电路板排列问题和连续邮资问题
- 备份注册表操作
- JSP常见的指令有哪些?(面试必备)
- 简化函数调用之八 :Replace Parameter with Method(以函数取代参数)