Error 310 - Table (xxxxxxxx) already exists in database

[checc...@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]

> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

You need to create an ansi database.
--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

[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.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

WebRep

currentVote

noRating

noWeight

[checc...@libero.it]

Well, this is what I need
Thank you!