How to use LogMiner on Oracle 11g

1. Setting date format.

   SAKURA@127.0.0.1:15210/orcl> alter system set nls_date_format='yyyy-mm-dd hh24:mi:ss' scope=spfile;
   SAKURA@127.0.0.1:15210/orcl> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

2. Enabling supplemental logging.

   SAKURA@127.0.0.1:15210/orcl> SELECT SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI FROM V$DATABASE;
   
   SUP SUP
   --- ---
   NO  NO
   
   SAKURA@127.0.0.1:15210/orcl> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;
   
   Database altered.
   
   SAKURA@127.0.0.1:15210/orcl> SELECT SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI FROM V$DATABASE;
   
   SUP SUP
   --- ---
   YES YES