под администратором ошибки нет, под любым пользователем такие ошибки в логе:
18.05.2009 12:37:39 [GAL#TESTBD]:
DELETE FROM GAL."SYS#LOCKS" WHERE DBSESSIONID NOT IN (SELECT GAL."INTTOHEX"(SID,4)||GAL."INTTOHEX"(SERIAL#,4) FROM V$SESSION WHERE STATUS <> 'KILLED')
ORA-00942: table or view does not exist
18.05.2009 12:37:39 [GAL#TESTBD]:
DELETE FROM GAL."X$ACTIVEUSERS" WHERE DBSESSIONID NOT IN (SELECT GAL."INTTOHEX"(SID,4)||GAL."INTTOHEX"(SERIAL#,4) FROM V$SESSION WHERE STATUS <> 'KILLED')
ORA-00942: table or view does not exist
Проблема с правами на Оракле ORA-00942 V$SESSION
Модераторы: m0p3e, edward_K, Модераторы
-
san
- Местный житель
- Сообщения: 412
- Зарегистрирован: 28 апр 2005, 11:34
- Откуда: Галактика Млечный Путь
Сделали все как описано в CHKORA_EXE_54180.txt
Результат - ошибка осталась, текст запроса изменился
19.05.2009 06:06:46 [GAL#SOKOLOVVV]:
DECLARE PRAGMA AUTONOMOUS_TRANSACTION; L_SESS GAL."GAL_HEXARRAY_TT"; BEGIN SELECT GAL."INTTOHEX"(SID,4) || GAL."INTTOHEX"(SERIAL#,4) BULK COLLECT INTO L_SESS FROM V$SESSION WHERE STATUS <> 'KILLED'; DELETE FROM GAL."SYS#LOCKS" WHERE DBSESSIONID NOT IN (SELECT * FROM TABLE(CAST(L_SESS AS GAL."GAL_HEXARRAY_TT"))); COMMIT; END;
ORA-06550: line 1, column 164:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 76:
PL/SQL: SQL Statement ignored
19.05.2009 06:06:46 [GAL#SOKOLOVVV]:
DECLARE PRAGMA AUTONOMOUS_TRANSACTION; L_SESS GAL."GAL_HEXARRAY_TT"; BEGIN SELECT GAL."INTTOHEX"(SID,4) || GAL."INTTOHEX"(SERIAL#,4) BULK COLLECT INTO L_SESS FROM V$SESSION WHERE STATUS <> 'KILLED'; DELETE FROM GAL."X$ACTIVEUSERS" WHERE DBSESSIONID NOT IN (SELECT * FROM TABLE(CAST(L_SESS AS GAL."GAL_HEXARRAY_TT"))); COMMIT; END;
ORA-06550: line 1, column 164:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 76:
PL/SQL: SQL Statement ignored
Результат - ошибка осталась, текст запроса изменился
19.05.2009 06:06:46 [GAL#SOKOLOVVV]:
DECLARE PRAGMA AUTONOMOUS_TRANSACTION; L_SESS GAL."GAL_HEXARRAY_TT"; BEGIN SELECT GAL."INTTOHEX"(SID,4) || GAL."INTTOHEX"(SERIAL#,4) BULK COLLECT INTO L_SESS FROM V$SESSION WHERE STATUS <> 'KILLED'; DELETE FROM GAL."SYS#LOCKS" WHERE DBSESSIONID NOT IN (SELECT * FROM TABLE(CAST(L_SESS AS GAL."GAL_HEXARRAY_TT"))); COMMIT; END;
ORA-06550: line 1, column 164:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 76:
PL/SQL: SQL Statement ignored
19.05.2009 06:06:46 [GAL#SOKOLOVVV]:
DECLARE PRAGMA AUTONOMOUS_TRANSACTION; L_SESS GAL."GAL_HEXARRAY_TT"; BEGIN SELECT GAL."INTTOHEX"(SID,4) || GAL."INTTOHEX"(SERIAL#,4) BULK COLLECT INTO L_SESS FROM V$SESSION WHERE STATUS <> 'KILLED'; DELETE FROM GAL."X$ACTIVEUSERS" WHERE DBSESSIONID NOT IN (SELECT * FROM TABLE(CAST(L_SESS AS GAL."GAL_HEXARRAY_TT"))); COMMIT; END;
ORA-06550: line 1, column 164:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 76:
PL/SQL: SQL Statement ignored
.