× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2013-12-09T17:27:16Z  · tariqrahiman last modified 2013-12-10T23:10:18Z

Oracle -> Extract Index -> Extraction schema of index incorrectly


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"))
GO
ALTER TABLE "HR"."AB" ADD ( CONSTRAINT "NEWCONSTRAINT" UNIQUE ("A", "C") )
GO
CREATE UNIQUE INDEX "IX"."skey" ON "HR"."AB"("A", "B", "C")
 
When recreating this object the "IX"."skey" is been recreated as "HR"."skey"

Issue #10989

Closed
Fixed
Resolved 2013-12-09T17:28:11Z
 
 
Completion
No due date
Fixed Build 14.0.5-10
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017