I am on Oracle 12c.
When we use DBMS_METADATA.get_ddl('CONSTRAINT', 'CONSTRAINT_NAME', ORACLE_OWNER, 'COMPATIBLE')
we are getting
using index (Create Index...
ALTER TABLE "OWNER"."CUSTOMER_DIM" ADD CONSTRAINT "EFDA_CIS_CUSTOMER_DIM_PK" PRIMARY KEY ("CUSTOMER_KEY")
USING INDEX (CREATE UNIQUE INDEX "EFDAREP"."EFDA_CIS_CUSTOMER_DIM_PK_IX" ON "EFDAREP"."EFDA_CIS_CUSTOMER_DIM" ("CUSTOMER_KEY")
) ENABLE NOVALIDATE;
We don't want the CREATE UNIQUE INDEX
part.
We only want using index and enable no validate.
This worked in 11g but is doing this by default in 12c.
Any ideas on how to get what we need besides replacing part of the returned data?
thanks
greG