Re: AW: dbimport error - FR 153256

Feature Request FR153265 (entered by Yours Truly on 2001-10-10) covers=20 this: DBIMPORT CANNOT IMPORT SOME DATABASES SUCCESSFULLY IMPORTED WITH DBEXPORT. DBEXPORT CANNOT EXPORT SOME DATABASES AT ALL. The long description starts "If you have a table that requires a=20 description bigger than the size of a single SQL statement (eg, a table=20 with lots of columns ..." The tables DB-Export has problems with are those owned by a 'user' with=20 non-alphanumeric characters in the name - created with DELIMIDENT set in=20 the environment. To import the table, you will have to take the DB-Export file, remove the=20 references to this table (foreign keys? stored procedures? permissions?) = and save them in a separate file. Run the rest of the import. Split the 'CREATE TABLE' statement into one CREATE and several ALTER TABLE = statements. Add the references to this table that you previously saved. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Information Management Division 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 05/12/2005 12:52:15 AM: > to create a table with 10000 columns you would need a huge=20 SQL-statement, > larger than the limit of 64 KB . > To verify that you could do a dbschema -ss -d <database> -t <table> > cr=5Ftable.sql > and try to run that sql-file: dbaccess <new=5Fdb> < cr=5Ftable.sql=20 > I think you will get the same error. >=20 > Possible solution: Change the SQL-file in the dbexport/dbimport=20 directory > not to create/load the huge tables. After the dbimport create the tables > manually (create a small part of the table, run a few alter tables :-? ) = and > try to load the data manually (load or dbload). Good luck! >=20 > Or: Ask the application developer if the table is correct! It doesn't=20 look > like a good relational model :-) > > -----Urspr=FCngliche Nachricht----- > > Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]Im > > Auftrag von CHANATIP LA.... > > Gesendet: Donnerstag, 12. Mai 2005 06:48 > > An: ids@iiug.org > > Betreff: dbimport error [4915] > >=20 > >=20 > > I export and import database. But when import it has error=20 > > statement too long. > > I found some table have about 10000 columns. like this > >=20 > > tabname res1290 > > owner idsdb > > partnum 3166547 > > tabid 122382 > > rowsize 22136 > > ncols 10939 > > nindexes 1 > > nrows 342 > > created 05/09/2005 > > version -565247951 > > tabtype T > > locklevel P > > npused 342 > > fextsize 5012 > > nextsize 5012 > > flags 0 > >=20 > > Informix Dynamic Server Version 9.30.HC4 > >=20 > > anyone have any idea? How to import this table?