Error 310 - Table (xxxxxxxx) already exists in database

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

On 17/05/13 10:04, checco_vero@libero.it wrote: > 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 > _______________________________________________ > Informix-list mailing list > Informix-list@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

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. On Fri, May 17, 2013 at 5:04 AM, <checco_vero@libero.it> wrote: > 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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > WebRep currentVote noRating noWeight

Well, this is what I need Thank you!