{"id":492,"date":"2014-11-28T15:24:27","date_gmt":"2014-11-28T07:24:27","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=492"},"modified":"2015-09-10T21:53:02","modified_gmt":"2015-09-10T13:53:02","slug":"dbms_errlog-create_error_log-%e8%ae%b0%e5%bd%95%e9%94%99%e8%af%af%e6%97%a5%e5%bf%97","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=492","title":{"rendered":"DBMS_ERRLOG.CREATE_ERROR_LOG\u8bb0\u5f55\u9519\u8bef\u65e5\u5fd7"},"content":{"rendered":"

DBMS_ERRLOG\u5305\u63d0\u4f9b\u4e86\u4e00\u4e2a\u7a0b\u5e8f,\u4f7f\u60a8\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u9519\u8bef\u65e5\u5fd7\u8868,
\n\u4ee5\u4fbfDML\u64cd\u4f5c\u540e\u53ef\u4ee5\u7ee7\u7eed\u9047\u5230\u9519\u8bef\u800c\u4e0d\u662f\u7ec8\u6b62\u548c\u56de\u6eda\u3002\u8fd9\u4f7f\u60a8\u80fd\u591f\u8282\u7701\u65f6\u95f4\u548c\u7cfb\u7edf\u8d44\u6e90\u3002<\/p>\n

–\u9996\u5148\u521b\u5efa\u4e00\u5f20\u6d4b\u8bd5\u8868 A
\nCREATE TABLE a (ID NUMBER PRIMARY KEY);<\/p>\n

BEGIN
\n— DBMS_ERRLOG.create_error_log(dml_table_name => ‘A’);
\nDBMS_ERRLOG.create_error_log(dml_table_name => ‘A’,err_log_table_name => ‘A_LOG’);
\nEND;<\/p>\n

–\u8fd9\u4e2a\u65f6\u5019\u53bb\u67e5 \u53ef\u4ee5\u53d1\u73b0\u591a\u51fa\u6765\u4e86\u8868ERR$_A\u548cA_LOG
\nSELECT * FROM tab<\/p>\n

–\u4e24\u5f20\u8868\u7684\u8868\u7ed3\u6784\u5b8c\u5168\u76f8\u540c
\nSELECT * FROM ERR$_A;
\nSELECT * FROM A_LOG;<\/p>\n

ORA_ERR_NUMBER$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –\u9519\u8bef\u8bb0\u5f55\u6570
\nORA_ERR_MESG$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(2000)\u00a0\u00a0 –\u9519\u8bef\u4fe1\u606f
\nORA_ERR_ROWID$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ROWID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –\u9519\u8bef\u8bb0\u5f55\u7684rowid(\u4ec5\u5bf9update\u6216delete)
\nORA_ERR_OPTYP$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(2)\u00a0\u00a0\u00a0\u00a0\u00a0 –\u64cd\u4f5c\u7c7b\u578b(I-INSERT,U-UPDATE,D-DELETE)
\nORA_ERR_TAG$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(2000)\u00a0\u00a0 –\u81ea\u5b9a\u4e49\u6807\u5fd7\u8bf4\u660e
\nA_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(4000)\u00a0\u00a0 –\u539f\u8868\u5b57\u6bb5<\/p>\n

\u5176\u4e2d\u524d\u4e94\u4e2a\u5b57\u6bb5\u662f\u56fa\u5b9a\u7684,\u540e\u8fb9\u5b57\u6bb5\u6839\u636e\u539f\u8868\u786e\u5b9a.
\n\u4f46\u662f\u539f\u8868\u548c\u5bf9\u5e94error log\u8868\u7684\u5b57\u6bb5\u7c7b\u578b\u662f\u4e0d\u5b8c\u5168\u5339\u914d\u7684,
\n\u5176\u8f6c\u6362\u89c4\u5219\u5982\u4e0b:
\nNUMBER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(4000)
\nCHAR\/VARCHAR2(n)\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0 VARCHAR2(4000)
\nNCHAR\/NVARCHAR2(n)\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0\u00a0 NVARCHAR2(4000)
\nDATE\/TIMESTAMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(4000)
\nRAW\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RAW(2000)
\nROWID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UROWID
\nLONG\/LOB\u00a0\u00a0\u00a0\u00a0 –>\u00a0\u00a0\u00a0\u00a0 LOB<\/p>\n

DBMS_ERRLOG.CREATE_ERROR_LOG (
\ndml_table_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2,–DML\u7684\u540d\u79f0\u8868\u57fa\u7840\u4e0a\u7684\u9519\u8bef\u65e5\u5fd7\u8868
\nerr_log_table_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 := NULL,–\u60a8\u5c06\u521b\u5efa\u9519\u8bef\u65e5\u5fd7\u8868\u7684\u540d\u79f0\u3002\u9ed8\u8ba4\u7684\u662f\uff08\u6700\u591a25\u5b57\u7b26\uff09DML\u8868\u524d\u7f00\u7684\u540d\u79f0’ERR$_\u2018\u3002\u4f8b\u5b50\u5982\u4e0b:dml_table_name: ‘EMP’, err_log_table_name: ‘ERR$_EMP’
\nerr_log_table_owner\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 := NULL,–\u9519\u8bef\u65e5\u5fd7\u8868\u7684\u6240\u6709\u8005\u7684\u540d\u79f0\u3002\u60a8\u53ef\u4ee5\u6307\u5b9adml_table_name\u7684\u6240\u6709\u8005
\nerr_log_table_space\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 := NULL,–\u9519\u8bef\u65e5\u5fd7\u8868\u5c06\u88ab\u521b\u5efa\u7684\u8868\u7a7a\u95f4\u3002\u5982\u679c\u6ca1\u6709\u6307\u5b9a,\u9ed8\u8ba4\u8868\u7a7a\u95f4\u4e3a\u7528\u6237\u62e5\u6709\u5c06\u4f7f\u7528DML\u9519\u8bef\u65e5\u5fd7\u8868
\nskip_unsupported\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN BOOLEAN := FALSE);–\u8bbe\u7f6e\u4e3aTRUE\u65f6,\u4e0d\u652f\u6301\u7684\u5217\u7c7b\u578b\u9519\u8bef\u65e5\u5fd7\u5c06\u88ab\u8df3\u8fc7,\u800c\u4e0d\u662f\u6dfb\u52a0\u5230\u9519\u8bef\u65e5\u5fd7\u8868\u3002\u8bbe\u7f6e\u4e3aFALSE\u65f6,\u4e00\u4e2a\u4e0d\u53d7\u652f\u6301\u7684\u5217\u7c7b\u578b\u5c06\u5bfc\u81f4\u7a0b\u5e8f\u7ec8\u6b62\u3002<\/p>\n

INSERT INTO a VALUES(1) LOG ERRORS
\n–INTO A_LOG\u00a0 \u53ef\u4ee5\u6307\u5b9a\u5230\u81ea\u5df1\u7684\u8868\u91cc \u4e5f\u53ef\u4ee5\u4e0d\u5199 \u9ed8\u8ba4\u5c31\u662fERR$_\u7684
\nREJECT LIMIT UNLIMITED; –\u5f53insert into\u591a\u884c\u8bb0\u5f55\u65f6 \u6700\u591a\u53ef\u4ee5\u5bb9\u5fcd\u591a\u5c11\u9519\u8bef\u3002<\/p>\n

–\u5f53\u7136 \u76f4\u63a5\u8fd9\u6837\u4e5f\u662f\u53ef\u4ee5\u7684
\nINSERT INTO a VALUES(1) LOG ERRORS<\/p>\n","protected":false},"excerpt":{"rendered":"

DBMS_ERRLOG\u5305\u63d0\u4f9b\u4e86\u4e00\u4e2a\u7a0b\u5e8f,\u4f7f\u60a8\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u9519\u8bef\u65e5\u5fd7\u8868, \u4ee5\u4fbfDML\u64cd\u4f5c\u540e\u53ef\u4ee5\u7ee7\u7eed\u9047\u5230\u9519\u8bef\u800c\u4e0d\u662f\u7ec8 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34,2],"class_list":["post-492","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-oracle_basics"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=492"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/492\/revisions"}],"predecessor-version":[{"id":1009,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/492\/revisions\/1009"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=492"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}