export user objects generates invalid code

[rbischof]

Hello,
we use named unique constraints with named indices.
The generator finds all objects, but it creates wrong order and no dependencies.
The statement is:
alter table ... add constraint c1 unique ... ;
create unique index i1 ...;
The statement must be:
create unique index i1 ...;
alter table ... add constraint c1 unique ... using index i1;
Best regards Reinhard

 

[Marco Kalter]

Can you send me the original (correct) DDL for this table and its constraints and indexes?

 

[rbischof]

Hello Marco,
at first the wrong generated code(windows):
prompt^M
prompt Creating table BEFUN^M
prompt ====================^M
prompt^M
create table BEFUN^M
(^M
BD_GR_NAME VARCHAR2(2) not null,^M
EL_NAME CHAR(3) not null,^M
GR_NAME_COPY VARCHAR2(2),^M
EL_SORT CHAR(3),^M
BEFUND1 VARCHAR2(68),^M
BEFUND2 VARCHAR2(55),^M
KZ_BEARB VARCHAR2(1),^M
LEIST_ERBRINGER VARCHAR2(68),^M
UPDATE_NR NUMBER(18) not null^M
)^M
;^M
alter table BEFUN^M
add constraint P_BEFUN primary key (BD_GR_NAME, EL_NAME);^M
alter table BEFUN^M
add constraint UK_BEFUN_UPDATE_NR unique (UPDATE_NR);^M
alter table BEFUN^M
add constraint U1_BEFUN unique (GR_NAME_COPY, EL_SORT);^M
create unique index BD_SORT on BEFUN (GR_NAME_COPY, EL_SORT);^M
-----------------------------------------
create unique index BD_SORT on BEFUN (GR_NAME_COPY, EL_SORT)
*
FEHLER in Zeile 1:
ORA-01408: Diese Spaltenliste hat bereits einen Index
-----------------------------------------
and now the the correct running statements(unix):
prompt
prompt Creating table BEFUN
prompt ====================
prompt
drop table BEFUN;
create table BEFUN
(
BD_GR_NAME VARCHAR2(2) not null,
EL_NAME CHAR(3) not null,
GR_NAME_COPY VARCHAR2(2),
EL_SORT CHAR(3),
BEFUND1 VARCHAR2(68),
BEFUND2 VARCHAR2(55),
KZ_BEARB VARCHAR2(1),
LEIST_ERBRINGER VARCHAR2(68),
UPDATE_NR NUMBER(18) not null
)
;
alter table BEFUN
add constraint P_BEFUN primary key (BD_GR_NAME, EL_NAME);
alter table BEFUN
add constraint UK_BEFUN_UPDATE_NR unique (UPDATE_NR);
create unique index BD_SORT on BEFUN (GR_NAME_COPY, EL_SORT);
alter table BEFUN
add constraint U1_BEFUN unique (GR_NAME_COPY, EL_SORT)
using index BD_SORT;
--
Is there a way to upload files?
--
Best regards Reinhard

 

[Marco Kalter]

Thanks. We'll fix this.