Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use enable_ddl_logging in oracle12c, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Set parameters, dynamic parameters

SQL > alter system set enable_ddl_logging=true;System altered.SQL > create table t (id int); Table created.SQL > alter session set container=pdb1;Session altered.SQL > drop table t _ table dropped.SQL >

2. View the ddl log

$cd ddl$lslog.xml$tail-f log.xml level='16' host_id='roidb01' host_addr='fe80::9e8:140c:99e6:7ad9%enp0s3' > truncate table t create table t (id int) drop table t ^ ClearpwdUniverse U01Applable ordbmsUnigram RdbmsGetWord path is here above $$is all the contents of this article entitled "how to use enable_ddl_logging in oracle12c". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.