I am using SQL Developer Version 4.0.3.16 w/ Oracle dB 10.2 to export (Tools -> Database export -> Export DDL) a table script to an external file. But the output file produced from the export does not include the same attributes as the table script in Developer. Why? Is this a bug or feature? Is there a way I can produce an external file w/ the exact same DDL as the table script in Developer? If there is, how? See example below:
The following is a part of the table script that I exported to an external file from Developer:
CREATE TABLE "HMMS"."EMP"
( "EMP_ID" NUMBER(11,0) NOT NULL ENABLE,
"NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"ASSIGNED_ORG_ID" VARCHAR2(7 BYTE) NOT NULL ENABLE,
"RATE_OF_PAY" NUMBER(7,3) NOT NULL ENABLE,
"LOC_ORG_ID" VARCHAR2(7 BYTE),
"LABOR_CLASS_CODE" NUMBER(5,0),
..
But, the contents of the output file produced from the export are:
--------------------------------------------------------
-- File created - Wednesday-January-28-2015
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table EMP
--------------------------------------------------------
CREATE TABLE "HMMS"."EMP"
( "EMP_ID" NUMBER(11,0),
"NAME" VARCHAR2(50 BYTE),
"ASSIGNED_ORG_ID" VARCHAR2(7 BYTE),
"RATE_OF_PAY" NUMBER(7,3),
"LOC_ORG_ID" VARCHAR2(7 BYTE),
"LABOR_CLASS_CODE" NUMBER(5,0),
...
Why the output file does not contain "NOT NULL ENABLE" for the first 4 columns? How can I save the table script to a file without using copy/paste? Any/all the help on this would be greatly appreciated.