Re: reorgainising dbspaces

Posted in 1999

Sergey Turin — Thu, 21 Oct 1999 14:18:57 +0400 — source: Informix-list mailing list archive (1991-1998)

Hi, Create one extra level 0 achive just after re-creating dbspaces. To import a table to certain dbspace (non-default for the database) you need to amend <db_name>.sql SQL script in <db_name>.exp directory created by dbexport. Add magic words at the end of CREATE TABLE statement for the table : IN <dbspace> etc (see SQL reference manual) I think it's better to have only 1 chunk per dbspace, this way, you can control where tables are to be placed. Hope this helps, Sergey