I almost forgot that we have this nice forum for questions like this.
About two weeks ago, I was reversed engineering a mysql db with SDE 4.0 (with internet updates) into a ER diagram. That worked fine.
But I did that as I wanted to convert it to a Oracle 8 DDL for the test and production environment.
However, I changed the default db and generated the DDL, but Oracle was complaining a lot about the DDL, and didn’t like it. Type of errors: simple things like quotes till syntax errors.
How can I solve this? what is the best way to deal with this?
create table authorization (id_user varchar2(32) not null,
authorizationSubject varchar2(32) not null, authorizationRole varchar2(32),
primary key (id_user, authorizationSubject), constraint “PRIMARY” unique
(id_user, authorizationSubject))
ORA-02261: such unique or primary key already exists in the table
create table traffic_number (id varchar2(32) not null, objectVersion
number(10) default 0 not null, number varchar2(200) not null,
idTrafficSubject varchar2(32) not null, primary key (id))
ORA-00904: : invalid identifier
create table user_properties (value varchar2(255), id_user varchar2(32) not
null, userPropertyName varchar2(32) not null, primary key (id_user,
userPropertyName), constraint PRIMARY1 unique (id_user, userPropertyName))
ORA-02261: such unique or primary key already exists in the table
create index FKDD091059FF75BD20 on authorization (authorizationRole)
ORA-00942: table or view does not exist
create index FKDD0910598880627C on authorization (id_user)
ORA-00942: table or view does not exist
create index FKDD09105962F65882 on authorization (authorizationSubject)
ORA-00942: table or view does not exist
create index indexAuthorizationRoleKey on authorization_role (keyCode)
ORA-01408: such column list already indexed
I am sorry but can’t do that anymore.
I used another way to solve it already.
We tried in several ways with a clean fresh new database and always got this errors.