Vincent的专栏

Oracle 9i数据库，执行下面语句出现错误“ORA-01791: 不是 SELECTed 表达式”：select distinct t.name from auth_employee t order by t.auth_employee_id asc 原来：SELECT语句中含有DISTINCT关键字或者有运算符时，排序用字段必须与SELECT语句中的字段相对应。 网上搜到解释如下：在OR

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

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

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

oracle 大对象移动表空间 ALTER INDEX GHSJ_JCSJ.SYS_IL0000129600C00012$$ REBUILD  TABLESPACE GHSJ_JCSJ   ORA-02327: cannot create index on expression with datatype LOB   将lob对象对应的列移动到相应的表空间，会自动创建之前的索引 ALT

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