Hi Simmon and Superboer thanks you for your suggestions.
I tried out the RAW table and it works like a charm, it was exactly what
I was looking for.
Thanks a lot.

Regards,
Aash

-----Original Message-----
From: owner-informix-list@iiug.org
[ mailtowner-informix-list@iiug.org
<mailtowner-informix-list@iiug.org> ]On Behalf Of Simmons, Keith
Sent: Friday, December 09, 2005 7:41 PM
To: informix-list@iiug.org
Subject: RE: Moving Informix TableSpaces between databases



Aash

You don't tell us which version of IDS you are using, however have you
investigated RAW tables (if they are avaialable in your version). They
can be created in logged or unlogged dbs and can allow the type of
access you require. RAW tables cannot be indexed or have constraints,
but the table can be changed to STANDARD (very quickly) and then be
indexed. You will not need any intermediate files, just INSERT INTO
'raw_table' SELECT FROM 'source_table'.

Keith

-----Original Message-----
From: Aashish Ramsinghani - ASDC, Chennai [ mailto:Aashishsr@hcl.in
<mailto:Aashishsr@hcl.in> ]
Sent: Friday, December 09, 2005 13:01
To: informix-list@iiug.org
Subject: Moving Informix TableSpaces between databases


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

************************************************** **********************
**********
This message is sent in strict confidence for the addressee only. It
may
contain legally privileged information. The contents are not to be
disclosed
to anyone other than the addressee. Unauthorised recipients are
requested
to preserve this confidentiality and to advise the sender immediately of
any
error in transmission.
This footnote also confirms that this email message has been swept for
the
presence of computer viruses, however we cannot guarantee that this
message
is free from such problems.
************************************************** **********************
**********
sending to informix-list

DISCLAIMER:
------------------------------------------------------------------------
--------------------------------------

This e-mail contains confidential and/or privileged information. If you
are not the intended recipient
(or have received this e-mail in error)please notify the sender
immediately and destroy this e-mail.
Any unauthorized copying, disclosure, use or distribution of the
material in this e-mail is strictly forbidden.
------------------------------------------------------------------------
---------------------------------------
sending to informix-list