Toad World® Forums

Oracle Primary Key Indexes are not Generating


#1

Hi,

Please see the generated script (Model | Generate DDL Script).

/*
Created: 1/17/2009
Modified: 1/17/2009
Model: Purchase Request (Equipment, Supply, IT)
Database: Oracle 10g
*/

– Create tables section -------------------------------------------------

– Table WCC.PR_PURCHASE_REQUESTS

CREATE TABLE WCC.PR_PURCHASE_REQUESTS(
PR_NUMBER Number(9,0) NOT NULL,
PR_STATUS_CODE Varchar2(2 BYTE) NOT NULL,
DATE_SUBMITTED Date NOT NULL,
REQUESTOR_FL_NAME Varchar2(64 BYTE) NOT NULL,
BILLING_CATEGORY Varchar2(20 BYTE) NOT NULL,
SECTION_MGR_FL_NAME Varchar2(30 BYTE) NOT NULL,
ORDER_STATUS Varchar2(15 BYTE) NOT NULL,
ORG_SOURCE Varchar2(20 BYTE) NOT NULL,
ORG_DATE Date NOT NULL,
CHG_SOURCE Varchar2(30 BYTE),
CHG_DATE Date,
REQUESTOR_USER_ID Varchar2(20 BYTE) NOT NULL,
SECTION_MGR_USER_ID Varchar2(20 BYTE) NOT NULL
)
TABLESPACE WCPD_DATA_TS
;

– Add keys for table WCC.PR_PURCHASE_REQUESTS

ALTER TABLE WCC.PR_PURCHASE_REQUESTS ADD CONSTRAINT PR_PURCHASE_REQUEST_PK PRIMARY KEY (PR_NUMBER)
USING INDEX PR_PURCHASE_REQUEST_PK_I
;

– Create relationships section -------------------------------------------------

CREATE INDEX PRSTTSRQRD_I ON WCC.PR_PURCHASE_REQUESTS (PR_STATUS_CODE)
TABLESPACE WCPD_INDEX_TS
;
ALTER TABLE WCC.PR_PURCHASE_REQUESTS ADD CONSTRAINT PRSTTSRQRD_FK FOREIGN KEY (PR_STATUS_CODE) REFERENCES WCC.PR_STATUS_CODES (PR_STATUS_CODE)
;

The Oracle Primary Key Indexes are no longer generating in front of the Alter Table Add Constraint Primary Key The Name of the Using Index is filled in and so is the Tablespace.

Is this because the index is automatically created by the database when the constraint is enabled and that is why the script do not contain it?

Regards,
Yew Wee


#2

Hello Yew,

We suppose the DDL you sent us is a DDL from model created during RE.
We need the original DDL (DDL executed in database before you did RE).

Thanks for it in advance.

Regards,

Vladka + TDM Team


#3

It is resolved now.

Create all Keys was not selected under the Extended Value