{"id":11580,"date":"2019-04-23T08:58:31","date_gmt":"2019-04-23T08:58:31","guid":{"rendered":"https:\/\/dbtut.com\/?p=11580"},"modified":"2019-04-23T08:58:31","modified_gmt":"2019-04-23T08:58:31","slug":"how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/","title":{"rendered":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)"},"content":{"rendered":"<h2>Enable DDL Auditing in 11g<\/h2>\n<p>It is possible to enable ddl auditing in a database or shema. In this way, we can monitor all DDL changes and we can undo the wrong operation in case of a problem.<\/p>\n<p>Create a table and trigger to audit all DDL operations in the database.<\/p>\n<h3>Create a Table for DDL Auditing<\/h3>\n<pre class=\"lang:default decode:true \">CREATE TABLE AUDIT_DDL\n(\n   D              DATE,\n   OSUSER         VARCHAR2 (255),\n   SESSION_USER   VARCHAR2 (255),\n   HOST           VARCHAR2 (255),\n   TERMINAL       VARCHAR2 (255),\n   MODULE         VARCHAR2 (255),\n   OWNER          VARCHAR2 (30),\n   TYPE           VARCHAR2 (30),\n   NAME           VARCHAR2 (30),\n   SYSEVENT       VARCHAR2 (30),\n   SQL_TEXT        VARCHAR2 (4000)\n);<\/pre>\n<h3>Create a Trigger For DDL Auditing<\/h3>\n<p>The following trigger will enable DDL auditing at the entire database level. If you write &#8220;on schema&#8221; instead of &#8220;on database&#8221; in the trigger, it will enable DDL auditing for only the user who created the trigger.<\/p>\n<pre class=\"lang:default decode:true  \">create or replace trigger audit_ddl_trg after ddl on database\ndeclare\n  sql_text ora_name_list_t;\n  stmt VARCHAR2(4000) := '';\n  n number;\nbegin\n    n:=ora_sql_txt(sql_text);\n    for i in 1..n\n    loop\n      stmt:=substr(stmt||sql_text(i),1,4000);\n    end loop; \n    insert into audit_ddl(d, osuser,session_user,host,terminal,module,owner,type,name,sysevent,sql_txt)\n    values(\n      sysdate,\n      sys_context('USERENV','OS_USER') ,\n      sys_context('USERENV','SESSION_USER') ,\n      sys_context('USERENV','HOST') , \n      sys_context('USERENV','TERMINAL') ,\n      sys_context('USERENV','MODULE') ,\n      ora_dict_obj_owner,\n      ora_dict_obj_type,\n      ora_dict_obj_name,\n      ora_sysevent,\n      stmt\n    );\nend;\n\/<\/pre>\n<h2>Enable DDL Auditing in 12c<\/h2>\n<p>It is possible to enable DDL auditing for Oracle 11g and earlier versions by performing the above operations.<\/p>\n<p>Oracle introduced a new feature with 12c; now it is possible to enable DDL auditing without needing these operations.<\/p>\n<p>When the ENABLE_DDL_LOGGING parameter is enabled, DDL changes can be logged in the following directory as log and xml file.<\/p>\n<pre class=\"lang:default decode:true  \">$ORACLE_BASE\/diag\/rdbms\/DBNAME\/SID\/log\/ddl<\/pre>\n<p>The parameter ENABLE_DDL_LOGGING can be changed as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; show parameter ENABLE_DDL_LOGGING\n\nNAME\t\t\t\t     TYPE\t\tVALUE\n---------------------------------------------\nenable_ddl_logging\t\t boolean\tFALSE\n\n\nSQL&gt; alter system set enable_ddl_logging=TRUE scope=both sid='*';\n\nSystem altered.\n\nNAME\t\t\t\t     TYPE\t\tVALUE\n---------------------------------------------\nenable_ddl_logging\t\t boolean\tTRUE<\/pre>\n<p>After the parameter change, in the first ddl operation, a file such as log.xml is created under the $ORACLE_BASE\/diag\/rdbms\/DBNAME\/SID\/log\/ddl directory and all the DDL operations are written as follows.<\/p>\n<pre class=\"lang:default decode:true \">&lt;msg time='2018-05-11T13:40:37.219+03:00' org_id='oracle' comp_id='rdbms'\n msg_id='opiexe:4695:2946163730' type='UNKNOWN' group='diag_adl'\n level='16' host_id='db01.local' host_addr='10.10.1.120'\n pid='326761' version='1'&gt;\n &lt;txt&gt;create table a(ad varchar(100))\n &lt;\/txt&gt;\n&lt;\/msg&gt;\n&lt;msg time='2018-05-11T13:55:40.162+03:00' org_id='oracle' comp_id='rdbms'\n msg_id='opiexe:4695:2946163730' type='UNKNOWN' group='diag_adl'\n level='16' host_id='db.local' host_addr='10.10.1.120'\n pid='393307'&gt;\n &lt;txt&gt;alter table a add soyad varchar(100)\n &lt;\/txt&gt;\n&lt;\/msg&gt;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11580\" class=\"pvc_stats all  \" data-element-id=\"11580\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Enable DDL Auditing in 11g It is possible to enable ddl auditing in a database or shema. In this way, we can monitor all DDL changes and we can undo the wrong operation in case of a problem. Create a table and trigger to audit all DDL operations in the database. Create a Table for &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11580\" class=\"pvc_stats all  \" data-element-id=\"11580\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11581,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[3365,3374,3375,3363,3364,3373,3366,3367,3369,3370,3371,3372,3368,3377,3376],"class_list":["post-11580","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-ddl-auditing-in-oracle","tag-enable-database-auditing-for-ddl-statements","tag-enable-database-auditing-for-ddl-statements-in-oracle","tag-enable-ddl-auditing-in-11g","tag-enable-ddl-auditing-in-12c","tag-enable_ddl_logging","tag-how-to-enable-ddl-auditing-in-oracle-11g","tag-how-to-enable-ddl-auditing-in-oracle-12c","tag-how-to-find-ddl-changes-in-oracle","tag-monitor-ddl-changes-in-oracle","tag-monitor-ddl-changes-in-oracle-11g","tag-monitor-ddl-changes-in-oracle-12c","tag-oracle-audit-ddl","tag-oracle-ddl-auditing","tag-turn-on-ddl-auditing"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3765,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-23T08:58:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png\" \/>\n\t<meta property=\"og:image:width\" content=\"535\" \/>\n\t<meta property=\"og:image:height\" content=\"331\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)\",\"datePublished\":\"2019-04-23T08:58:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\"},\"wordCount\":227,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png\",\"keywords\":[\"ddl auditing in oracle\",\"Enable Database Auditing for DDL statements\",\"Enable Database Auditing for DDL statements in oracle\",\"enable ddl auditing in 11g\",\"enable ddl auditing in 12c\",\"enable_ddl_logging\",\"how to enable ddl auditing in oracle 11g\",\"how to enable ddl auditing in oracle 12c\",\"how to find ddl changes in oracle\",\"monitor ddl changes in oracle\",\"monitor ddl changes in oracle 11g\",\"monitor ddl changes in oracle 12c\",\"oracle audit ddl\",\"Oracle DDL Auditing\",\"Turn on DDL auditing\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\",\"name\":\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png\",\"datePublished\":\"2019-04-23T08:58:31+00:00\",\"description\":\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png\",\"width\":535,\"height\":331},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials","description":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/","og_locale":"en_US","og_type":"article","og_title":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials","og_description":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-23T08:58:31+00:00","og_image":[{"width":535,"height":331,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)","datePublished":"2019-04-23T08:58:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/"},"wordCount":227,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png","keywords":["ddl auditing in oracle","Enable Database Auditing for DDL statements","Enable Database Auditing for DDL statements in oracle","enable ddl auditing in 11g","enable ddl auditing in 12c","enable_ddl_logging","how to enable ddl auditing in oracle 11g","how to enable ddl auditing in oracle 12c","how to find ddl changes in oracle","monitor ddl changes in oracle","monitor ddl changes in oracle 11g","monitor ddl changes in oracle 12c","oracle audit ddl","Oracle DDL Auditing","Turn on DDL auditing"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/","name":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png","datePublished":"2019-04-23T08:58:31+00:00","description":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-29.png","width":535,"height":331},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-enable-ddl-auditing-in-oracle-11g-and-12cenable_ddl_logging\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11580"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11580\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11581"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}