Error 310 - Table (xxxxxxxx) already exists in database
Francesco, importing a schema into Informix 11.70.FC2, got error 310 because two tables with the same name but different owners (SIACG.tabutin and SIAPR.tabutin) could not both be created. Marco Greco and Art Kagel explained that same-named tables with different owners need an ANSI-mode database, so dbimport must be run with the -ansi flag. Francesco confirmed this was what he needed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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!