11g sqlplus errorlog
11g sqlplus errorlog
=====================
11g新增的對sqlplus中錯誤記錄日誌
一旦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
--------------------------------------------------------------------------------
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> 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
---------- -------------------------------------------------- --------------------------------------------------------------------------------
AN create table atest as select * from atest ORA-00955: name is already used by an existing object
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13177610/viewspace-711100/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 11g SQLPLUS新增SHOW SPPARAMETER命令SQL
- 處理SQLServer errorlog滿問題SQLServerError
- SQL Server ErrorLog 錯誤日誌SQLServerError
- Oracle 11g在redhat 5 sqlplus 錯誤OracleRedhatSQL
- 11g優化了sqlplus的glogin指令碼優化SQL指令碼
- 11g啟動sqlplus報錯沒有許可權SQL
- SQLSERVER 2005 清除DB日誌和 ERRORLOG 的方法SQLServerError
- [20120106]11G sqlplus set errorloging on.txtSQLError
- SQLPlusSQL
- sqlplus spoolSQL
- sqlplus sqlpromptSQL
- sqlplus用法SQL
- sqlplus -premliSQLREM
- sqlplus提示SQL
- sqlplus(一)SQL
- 如何在solaris的oracle sqlplus中使用sqlplusOracleSQL
- 【SQLPLUS】sqlplus 客戶端所需的檔案列表SQL客戶端
- SQLPLUS 操作大全SQL
- sqlplus的使用SQL
- 讓sqlplus 飛SQL
- sqlplus set命令SQL
- sqlplus 基礎SQL
- SQLPLUS COPY 功能。SQL
- sqlplus 命令大全SQL
- sqlplus-helpSQL
- sqlplus小記SQL
- 檢視oralce10g,11g隱含引數,並在SQLPLUS視窗格式化輸出SQL
- windows sqlplus亂碼WindowsSQL
- sqlplus專用命令SQL
- sqlplus 使用總結SQL
- sqlplus column命令用法SQL
- sqlplus登陸方式SQL
- sqlplus 內部命令SQL
- sqlplus失去響應SQL
- sqlplus -prelim/ as sysdba用法SQL
- 隨筆 sqlplus / as sysdbaSQL
- rlwrap sqlplus in linuxSQLLinux
- 修改sqlplus的SQLPROMPTSQL