-
编辑 删除
IMPDP ORA-39014
10.2.0.3 impdp导入时报错ORA-39014 ORACLE的答复这是一个BUG，是由10.203存储过程的格式和10.204有差异造成的，这个问题目前没有补丁，要在10.205来解决，目前的解决方案是在10.204机器上重新编译一遍存储过...
-
编辑 删除
ORA-12720: operation requires database is in EXCLUSIVE mode
when re-create controlfile of 2-nodes RAC database, database prompted the following errors: ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-12720: operation requires database is in EXCL...
-
编辑 删除
ORA-01686:max # files (%s) reached for the tablespace %s
事实证明，一个表空间最多可以有1023个数据文件。今天加空间的时候出错，ora-01686SQL> alter tablespace USER_DATAadd datafile'/data/oracle/user_data_1021.dbf' size 1921m,'/data/oracle/user_data_1022.dbf' ...
-
编辑 删除
Add column in 11g
DDL Wait OptionJill the DBA at Acme Retailers is trying to alter the table called SALES to add a column, TAX_CODE. It's pretty routine stuff; she issues the following SQL statement:SQL> alter table ...
-
编辑 删除
Explain Plan usage
Explain Plan
搜博主文章
他的分类
- oracle?份恢?(4)
- 11g(1)
- oracle wait event(3)
- development(1)
- 用户及权限控制(2)
- Oracle Net(1)
- 技???(2)
- ?料??份?恢?(11)
- oracle management(3)
- ORA-erroid(4)
- MAA(1)
- Tool(6)
- Performance Tunning(2)
- 常用?件安?(1)
- 随笔 AND 摘录(1)
- oracle登???(1)
- Dataguard(2)
- redo and undo(2)
- Performance Tunning(1)
- oracle certify(2)
- ?算?技?(2)
- oracle security(2)
- 默认分类(2)
