Moving Informix TableSpaces between databases

Hi I am using Informix for one of my DW projects. I saw a thread about "moving tables between databases" but could not find anything in there. 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

--staging has it disabled. the tables in there you could potentially create them to be raw tables and make staging logging enabled. you can alter the table to be logged again followed by a lvl 0 archive or a fake lvl 0 archive another thing: you could create tables in a logged db and use the high perf loader to unload from staging to a fifo and load the tables in the logged db reading from the fifo in express mode. (rowsize has to be < pagesize else buffer cache wil be used...) configure the # of fifo's to write to equal to the # of cpus... and or # of dbspaces in which the table is fragmented... when the load is completed create a lvl 0 archive or a fake lvl 0 archive Superboer.