Hi There,
When we use the below script to create materialized view in 11g [11.2.0.4.3], It used to create unique index with name 'PK_PROPERTY', constraint with name 'PK_PROPERTY1'
CREATE MATERIALIZED VIEW PROPERTY_FIX (COL1,COL2,COL3,COL4,COL5)
TABLESPACE XXXXDATA
BUILD IMMEDIATE
USING INDEX TABLESPACE XXXXINDX
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
AS
SELECT *
FROM "PROPERTY"@"DBLINK_XXXX" "PROPERTY";
But after upgrading to 12c [ 12.1.0.2.5] when we use the same script as above , ORACLE is creating system generated unique index name ,constraint name starting with SYS_C_SNAP$_5PK_PROPERTY.
Is there any way we can enforce the ORACLE to create unique index, constraint with the name we wanted in 12c ?
Thanks,
Ram