以Oracle Mode 为例,在创建包、包体、存储过程时如果提示 warning 信息,可以通过查询 user_errors 视图查看编译过程的具体错误信息。 示例如下。 创建存储过程。 obclient [SYS]> create or replace procedure pro is a int := 1; begin b := 1; end; / Query OK, 0 rows affected, 1 warning (0.071 ...
user_ind_subpartitions 索引子分区 user_part_lobs 表中的LOB数据分区 user_lob_partitions LOB分区 user_lob_subpartitions LOB子分区 user_part_key_columns 已分区对象的分区关键字列 user_subpart_key_columns 使用组合范围/散列法分区的表的子分区关键字列 user_part_col_statistics 表分区统计和其他信息 user...
1 SQL> select * from user_errors where type='PACKAGE BODY' and name='CTODB_EVENT_PKG_EL'; 2 3 NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER 4 --- --- --- --- --- --- --- --- 5 CTODB_EVENT_PKG_EL PACKAGE BODY 1 609 25 PL/SQL: ORA-00942: table...
Oracle Errors provide user-friendly descriptions of Oracle ORA errors. In theConstraintfield, you can enter any text if the errors do not involve constraints. For errors that involve constraint failures, each constraint can map to a user-defined translatable message. The constraint field is the Or...
if (SQL%NOTFOUND) then Raise NO_DATA_FOUND; end if; END Delete_Row; END &PACKAGE_NAME; / show errors package body &PACKAGE_NAME SELECT to_date('SQLERROR') FROM user_errors WHERE name = '&PACKAGE_NAME' AND type = 'PACKAGE BODY' / commit; exit;...
(全部默认) errors -- 允许的错误的数目 (默认50) rows -- 常规路径绑定数组中或直接路径保存数据间的行数 (默认: 常规路径 64, 所有直接路径) bindsize -- 常规路径绑定数组的大小 (以字节计) (默认256000) silent -- 运行过程中隐藏消息 (标题,反馈,错误,废弃,分区) direct -- 使用直接路径 (默认...
SCOTT@PROD>insert into test select*from emp;SCOTT@PROD>commit;SCOTT@PROD>analyze table test compute statistics;SCOTT@PROD>select table_name,blocks,empty_blocks from user_tables where table_name='TEST'; 直接路径插入 代码语言:javascript 代码运行次数:0 ...
the following errors while trying to drop a user, who has no spatial tables,connected as SYSTEM:ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist ORA-06512: at line 7 A 942 error trace shows the failing SQL statement...
No errors in the db alert log. Another oddity is that sometimes the user can login, but then as soon as they log out then they cannot login again. It's like after a while, what ever is keeping the user from logging in is released and the user can login, but then once users log ...
1.启动报错ORA-03113 2.查看alert日志查找原因 3.根据实际情况采取合理的措施,这里我们先增加闪回区大小,把库启动起来 4.制定对应的归档日志删除策略 1.启动报错ORA-03113 $ sqlplus /as sysdba SQL*Plus: Release11.2.0.4.0Production on 星期六 2月2813:56:442015Copyright (c)1982,2013, Oracle. All rights...