Oracle 10g Import Issue

[lrites]

Hi there,

I have a dump taken by Oracle EXPORT:V10.01.00 and importing into 10.1.0.3 using Import: Release 10.1.0.3.0.

Problem Statement here is ....

We got a table T1 with Primarykey using Index. Issue is , when I drop the constraint it does not drop the Index which was associated with PK.

Normal behaviour is when we drop PK, it should drop the index as well.

Any inputs would be greatly appriciated.

[sambavan]

It depends on how the index constrain was created in first place.

Refer Metalink Note:139666.1
Subject: Explicit Control Over Indexes when Creating, Disabling, or Dropping PK/Unique Constraints


Thanx,
Sam