Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problems with reverse engineer and keys

14 views
Skip to first unread message

Maciej Kotok

unread,
Oct 28, 2003, 7:38:25 AM10/28/03
to
Im trying to reverse engineer script for Oracle 8.1.7 useing
PowerDesigner 9.5.1.736. The problem is that i cant reverse engineer
any keys - primary nor foregin.

here is the part of this script:


CREATE TABLE HOO_EKD
(Z_ID_EKD NUMBER(12) NOT NULL
,Z_ID_EKD_PARENT NUMBER(12) NOT NULL
,Z_NR_EKD NUMBER(10) NOT NULL
,Z_OPIS VARCHAR2(240) NOT NULL
,Z_SYSDATA DATE NOT NULL
,Z_USER VARCHAR2(16) NOT NULL
,Z_DATA_DO DATE
,Z_AKTUALNY VARCHAR2(1) NOT NULL
);

CREATE INDEX HOO_EKD ON HOO_EKD
(Z_ID_EKD_PARENT
,Z_NR_EKD);

ALTER TABLE HOO_EKD
ADD (CONSTRAINT EKD_PK PRIMARY KEY
(Z_ID_EKD)
EXCEPTIONS INTO HOO_ZLE_WIEZY);

and here what do i get in PD Output window

Reverse Engineering
Reverse engineers the file D:\tolek\tabele\scrypttest1.sql...

Lines 1 to 10: Table HOO_EKD
Lines 12 to 14: Index HOO_EKD
Lines 16 to 19: "ALTER TABLE HOO_EKD" skipped.

The file has been successfully reverse engineered.


And there is no primary key in my tabel... :(
Does any body know what should I do?

0 new messages