原表的定义是这样的
SQL> desc trswcm.wcmdocument
Name Type Nullable Default Comments
------------- -------------- -------- ------------ --------
DOCCONTENT CLOB empty_clob()
DOCABSTRACT VARCHAR2(2000) Y
DOCKEYWORDS VARCHAR2(200) Y
DOCRELWORDS VARCHAR2(200) Y
DOCPEOPLE VARCHAR2(200) Y
DOCPLACE VARCHAR2(200) Y
DOCAUTHOR VARCHAR2(200) Y
DOCOUTUPID NUMBER Y
CRUSER VARCHAR2(30) Y
CRTIME DATE Y
DOCRELTIME DATE Y
DOCHTMLCON CLOB empty_clob()
DOCORDER NUMBER 0
DOCVERSION NUMBER 0
DOCWORDSCOUNT NUMBER 0
RIGHTDEFINED NUMBER 0
用create table as创建出来的表里的默认值都没有了
Name Type Nullable Default Comments
------------- -------------- -------- ------- --------
DOCCONTENT CLOB
DOCABSTRACT VARCHAR2(2000) Y
DOCKEYWORDS VARCHAR2(200) Y
DOCRELWORDS VARCHAR2(200) Y
DOCPEOPLE VARCHAR2(200) Y
DOCPLACE VARCHAR2(200) Y
DOCAUTHOR VARCHAR2(200) Y
DOCOUTUPID NUMBER Y
CRUSER VARCHAR2(30) Y
CRTIME DATE Y
DOCRELTIME DATE Y
DOCHTMLCON CLOB
DOCORDER NUMBER
DOCVERSION NUMBER
DOCWORDSCOUNT NUMBER
RIGHTDEFINED NUMBER