dbimport - tables in specific dbspaces 1

[govmule]

Hello,

We're using Informix IDS 7.3.

Does anyone know how to modify the dbschema to tell which tables to load in which dbspaces for a dbimport. I forgot to use the -ss operator with a dbexport and then imported and now everything is in root db (noooo!). I don't want to use round robin.

Thanks in advance,

Jack Luster

 

[vpshriyan]

Jack,

if you have preserved all data of your earlier dbexport, you may edit your <database>.sql file. In all the "create table" and "create index" tables suffix "in <space_name>" syntax. Once you have completed this, drop the database and import the data afresh to multiple dbspaces.

In the process, you have also lost the original extent size and lock modes as well.

eg.
create table tab_x
(
col1 integer,
col2 varchar(30)
) in tablespace1 extent size 524 next size 128 lock mode row;

create index idx1 on tab_x (col1) in indexspace1;

It is bit surprising that you were able to accommodate whole of your business data in to rootdb alone! It means either you have less volume of data or have a huge rootdbs space size.

Good luck!