When asking for the DDL of an object owned by another schema, sqldeveloper attempts to use an "internal generator" instead of DBMS_METADATA. The odd thing is the way its results are presented in the "SQL" tab. For example, column comments or index definitions come before a CREATE TABLE, some statement separators are missing,etc (see an example below). The bits and pieces look alright (at least plausible) but the ordering needs reviewing.
Note that attempting "DDL SOME_SCHEMA.SOME_TABLE" in a worksheet results in a DBMS_METADATA error.
I am currently using v19.4 on WIN10 but have come across this puzzling result in previous versions, too.
-- Unable to render TABLE DDL for object SOME_SCHEMA.SOME_TABLE with DBMS_METADATA attempting internal generator.
COMMENT ON TABLE SOME_SCHEMA.SOME_TABLE IS 'some comment'CREATE INDEX SOME_SCHEMA.I_FK_SOME_TABLE_1 ON SOME_SCHEMA.SOME_TABLE (LOOPBAAN_ID ASC)
LOGGING
TABLESPACE SOME_SCHEMA_INDEX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE UNIQUE INDEX SOME_SCHEMA.PK_SOME_TABLE ON SOME_SCHEMA.SOME_TABLE (ID ASC)
LOGGING
TABLESPACE SOME_SCHEMA_INDEX
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLELALTER TABLE SOME_SCHEMA.SOME_TABLE
ADD CONSTRAINT PK_SOME_TABLE PRIMARY KEY
(
ID
)
USING INDEX SOME_SCHEMA.PK_SOME_TABLE
ENABLECOMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.ID IS 'some comment';
COMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.XYZ_ID IS 'some comment';
COMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.DT_BEGIN IS 'some comment';
COMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.VCFLD IS 'some comment';
COMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.USID_CHANGE IS 'some comment';
COMMENT ON COLUMN SOME_SCHEMA.SOME_TABLE.DT_CHANGE IS 'some comment';CREATE TABLE SOME_SCHEMA.SOME_TABLE
(
ID NUMBER(10, 0) NOT NULL
, XYZ_ID NUMBER(10, 0) NOT NULL
, DT_BEGIN DATE NOT NULL
, VCFLD VARCHAR2(10 CHAR) NOT NULL
, USID_CHANGE VARCHAR2(10 CHAR) NOT NULL
, DT_CHANGE DATE NOT NULL
)
LOGGING
TABLESPACE SOME_SCHEMA_DATA
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOCOMPRESS
NO INMEMORY
NOPARALLELALTER TABLE SOME_SCHEMA.SOME_TABLE
ADD CONSTRAINT FK_SOME_TABLE_1 FOREIGN KEY
(
LOOPBAAN_ID
)
REFERENCES SOME_SCHEMA.SOME_PARENT_TABLE
(
ID
)
ENABLE