CTAS will loss default value define on columns
The CTAS operation although copies column constraints such as NULL, NOT NULL from the normal table to the partitioned table during the partitioned table creation, it does not copy DEFAULT VALUEs of the columns.
script:purge ADR file
[oracle@db231 ~]$ ./adr_purge
INFO: Purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purging diagnostic destination diag/tnslsnr/db231/listener
INFO: purging ALERT older than 90 days …
INFO: purging INCIDENT older than 30 days …
ORA-12034: materialized view log on xx.xx younger than last refresh when a mview fast refresh after Impdp
ORA-12012: error on auto execute of job 88
ORA-12034: materialized view log on “TOPBOX”.”TOPBOX_COURSESTUDY” younger than last refresh
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2256
