#10989: Oracle -> Extract Index -> Extraction schema of index incorrectly

ivangron reported 2013-12-09T17:27:16Z · last modified 2013-12-10T23:10:18Z

Dev	ivangron
QA	tariqrahiman

Priority	Critical
Complexity	Unknown

Component	Tools - Compare - Schema
Version	14.0

If you created a table and then placed an index on the table that has a different schema owner it is scripting incorrectly. example:

CREATE TABLE "HR"."AB" (

"A" NUMBER(15,5) NOT NULL,

"B" NUMBER(15,5) NOT NULL,

"C" NUMBER(15,5) NOT NULL,

"D" VARCHAR2(25) NOT NULL,

CONSTRAINT "pkey" PRIMARY KEY("A"))

ALTER TABLE "HR"."AB" ADD ( CONSTRAINT "NEWCONSTRAINT" UNIQUE ("A", "C") )

CREATE UNIQUE INDEX "IX"."skey" ON "HR"."AB"("A", "B", "C")

When recreating this object the "IX"."skey" is been recreated as "HR"."skey"

All Comments (2) Change History

ivangron 2013-12-09T17:28:11Z

fixed extraction of index owner.

tariqrahiman 2013-12-10T23:10:18Z

Verified in 14.0.5-11