CONSTRAINT name GOOFS ? on export / IMPORT .. HELP!!

From: <bruce.taneja_at_mcd.com>
Date: Wed, 24 Jan 2001 13:58:56 -0600
Message-Id: <10751.127404@fatcity.com>

I did a full export on a 8.0.6 database
Created a new 8.1.7 database and did a full import with ignore=y

Now some of user tables in a schema are not created.. because of CONSTRAINT NAME already used! These names are like "SYS_C001963".. etc ..

IMPORT logs shows:
"CREATE TABLE... *snipped* xyz varchar2(14) CONSTRAINT "SYS_C001963" NOT NULL ENABLE ... *snipped*

ORA-02264: name already used by an existing constraint

There is another user table which is using this constraint name.. however in the original database it had a different constraint name..

Why is the successfully created table using the constraint name of the failed table,
and why is the failed table using hard coded system generated constraint name .. ??

Please help! Received on Wed Jan 24 2001 - 13:58:56 CST