
Oracle Troubleshooting
文章平均质量分 50
cloudsnowe
force on oracle
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
ORA-01791: 不是 SELECTed 表达式
Oracle 9i数据库,执行下面语句出现错误“ORA-01791: 不是 SELECTed 表达式”:select distinct t.name from auth_employee t order by t.auth_employee_id asc 原来:SELECT语句中含有DISTINCT关键字或者有运算符时,排序用字段必须与SELECT语句中的字段相对应。 网上搜到解释如下:在OR原创 2014-07-22 13:56:25 · 683 阅读 · 0 评论 -
ORA-10631: SHRINK clause should not be specified for this object
sys@GHSJDB> alter table "GHSJ_JCSJ"."T_PWZY_FHKG" shrink space; alter table "GHSJ_JCSJ"."T_PWZY_FHKG" shrink space * ERROR at line 1: ORA-10631: SHRINK clause should not be specified for this obje原创 2015-01-15 14:59:14 · 2240 阅读 · 0 评论 -
emctl start dbconsole遇到错误:OC4J Configuration issue
emctl start dbconsole 报如下错误: [oracle@server2 ~]$ emctl start dbconsole OC4J Configuration issue. /home/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_server2_ghsjdb not found. [or原创 2015-01-15 09:52:26 · 2340 阅读 · 0 评论 -
oracle 10gr2 ORA-27125: unable to create shared memory segment when run DBCA
I have installed 10gR2 on linux environment, When running DBCA it got filed with below error ORA-27125: unable to create shared memory segment SOLUTION: cd $ORACLE_HOME/bin mv oracle oracle.bin原创 2015-04-24 09:43:43 · 1032 阅读 · 0 评论 -
oracle lob move tablespace
oracle 大对象移动表空间 ALTER INDEX GHSJ_JCSJ.SYS_IL0000129600C00012$$ REBUILD TABLESPACE GHSJ_JCSJ ORA-02327: cannot create index on expression with datatype LOB 将lob对象对应的列移动到相应的表空间,会自动创建之前的索引 ALT原创 2015-05-29 17:09:01 · 1641 阅读 · 0 评论 -
aud$表空间迁移
system表空间的使用情况到了99%,查看占用最多空间的对象是aud$,使用DBMS_AUDIT_MGMT迁移到其他表空间1.查看表空间的使用情况sys@GHSJDB> select 2 b.tablespace_name "表空间", 3 b.bytes/1024/1024 "大小M", 4 (b.bytes-sum(nvl(a.bytes,0)))/1原创 2015-10-26 15:47:24 · 1268 阅读 · 0 评论