Moving Informix TableSpaces between databases

Posted in 2005

Aashish Ramsinghani - ASDC, Chennai — Fri, 9 Dec 2005 18:31:09 +0530 — source: Usenet: comp.databases.informix

Hi I am using Informix for one of my DW projects. We are loading data from the source system into the staging area both are separate Databases. Source has logging enables and staging has it disabled. The problem comes when I try to access data across both these databases. I cannot link tables between these databases because of their logging properties. So I am dumping the data into a CSV file and loading it again but for my initial load which consists of 40+ million records it is a problem. In oracle I know we can make a separate table space and dump the data there then load the table space to another database. I don't know if such a thing is possible in Informix. Any help will be appreciated. Thanks and Regards, Aash sending to informix-list