What do you mean by I didn't find details of these items in the help section?
I mean there was no detail associated with the Export DDL options.
What other details do you want? Provided that the DDL is complete/valid, that should be all you need.
I didn't need any other details, but I wanted to indicate that there was no other information in Help that would help me troubleshoot why these items were still showing up in the output even though I un-selected them.
I just exported a table with the values you selected and there was no Help text. There were comments though.
CREATE TABLE "BCGREX"
( "ID" NUMBER,
"REGEX" VARCHAR2(30 BYTE),
"DESCRIPTION" VARCHAR2(100 BYTE)
COMMENT ON COLUMN "BCGREX"."ID" IS 'ID of regex for searching source code';
I can't reproduce it.
Post ALL of the particulars about os and sql dev.
Have you tried shutting down sql dev and relaunching?
Does the user doing the export own the objects?
Have you cleared the cache and started over?