Re: A question about tbload

Posted in 1993

Jonathan Leffler — Mon, 21 Jun 93 10:14:49 GMT — source: Informix-list mailing list archive (1991-1998)

>From: uunet!andromeda.mty.itesm.mx!mmaldona (Ing. Maximo Maldonado Boyso) >Subject: A question about tbload >Date: 18 Jun 1993 18:54:47 GMT >X-Informix-List-Id: <news.3606> > >Do you know if tbload utility preserves >the dbspace in which a table resides? No, it doesn't. Indeed, one of its many uses is to relocate a table from one dbspace into another. According to the 5.00 manual beside me, if you do not specify a dbspace, the table ends up in the root dbspace. Blobspace blobs can be relocated into a new dbspace if required, and indexes can be renamed. Although the 5.00 manual is not clear on the point, you must specify either dbase:table or dbase:owner.table. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>