Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I noticed that when copying a table from one schema to another, if a column has a data default property it is not preserved.
Steps to recreate:
Copy a table that has at least one column with a non-null DATA_DEFAULT property (right click on table -> table -> copy)
Double click on the new table, and open the Columns tab. Notice that all values under DATA_DEFAULT are null.
The same behavious exists in 3.2.20.09 and whether the table has existing data or not.