11g sqlplus errorlog

=====================

11g新增的对sqlplus中错误记录日志
一旦sqlplus中发生错误会被记录到表中

------------------

--版本
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

、
--查看是否开启
SQL> show errorlog
errorlogging is OFF

--开启方法
SQL> set errorlog on

--再次查看开启情况
--如果开启会给出记录的表
SQL> show errorlog
errorlogging is ON TABLE AN.SPERRORLOG
SQL>

--刚刚开启之后表中没有数据
SQL> select * from sperrorlog;

no rows selected

--模拟错误
SQL> create table atest as select * from atest;
create table atest as select * from atest
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

--再次查看，其中会记录详细的错误信息
SQL> set wrap off
SQL> col username for a10
SQL> set linesize 300
SQL> col statement for a50
SQL> select * from sperrorlog;

USERNAME STATEMENT MESSAGE
---------- -------------------------------------------------- --------------------------------------------------------------------------------
AN create table atest as select * from atest ORA-00955: name is already used by an existing object

ITPub博客

11g sqlplus errorlog

最新文章