Error 310 - Table (xxxxxxxx) already exists in database

[c***@libero.it]

Hi all, I have a big problem these days:

I have to import an old database to Informix 11.70.FC2 on Linux. The old db also resides on 11.70.FC2, and contains several tables with different owner, but same name, eg:

create table "SIACG".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_operatore char(10),
tn_data_ins date,
tn_data_var date
);

create table "SIAPR".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_ditta integer,
tn_data_ins date,
tn_data_var date,
tn_operatore char(10)
);

Obviously, the second table has been not created while importing/running the schema file, giving back the error:

310: Table (SIAPR.tabutin) already exists in database.

How can I procede?

Thanks a lot,
Francesco

[Marco Greco]

Post by c***@libero.it
create table "SIACG".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_operatore char(10),
tn_data_ins date,
tn_data_var date
);
create table "SIAPR".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_ditta integer,
tn_data_ins date,
tn_data_var date,
tn_operatore char(10)
);
310: Table (SIAPR.tabutin) already exists in database.
How can I procede?
Thanks a lot,
Francesco
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

You need to create an ansi database.

[Art Kagel]

You can only have multiple tables with the same name but different owners
in an ANSI mode database. When you run dbimport you need to specify the
-ansi flag to create the new database in ANSI logging mode.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by c***@libero.it
I have to import an old database to Informix 11.70.FC2 on Linux. The old
db also resides on 11.70.FC2, and contains several tables with different
create table "SIACG".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_operatore char(10),
tn_data_ins date,
tn_data_var date
);
create table "SIAPR".tabutin
(
tn_tabella char(5),
tn_codice integer,
tn_descr char(70),
tn_integer integer,
tn_float decimal(20,6),
tn_data date,
tn_ditta integer,
tn_data_ins date,
tn_data_var date,
tn_operatore char(10)
);
Obviously, the second table has been not created while importing/running
310: Table (SIAPR.tabutin) already exists in database.
How can I procede?
Thanks a lot,
Francesco
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

WebRep
currentVote
noRating
noWeight

[c***@libero.it]

Well, this is what I need
Thank you!