RE: Informix Unload equivalent in Oracle

Hi Gregg. Just my $0.02. My experience, I used SQLDA via Pro*C. You can find sample program somewhere. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Gregg Walker" <greggNOSPAM@NOSPAMrrmca.com> >Reply-To: "Gregg Walker" <greggNOSPAM@NOSPAMrrmca.com> >To: informix-list@iiug.org >Subject: Informix Unload equivalent in Oracle >Date: Thu, 13 Jan 2005 16:28:50 -0800 > >Hi, > >I'm an experienced Informix db admin. The company I work for purchased a >system that uses Oracle for its backend a few years back. I need some help >with Oracle admin related to unloading and reloading data. > >I'm struggling to find a utility that works like the unload command in >informix to dump part of a table to an ascii file. > >Here's what I'm trying to do... > >I have tables that are partitioned. I need to unload all the rows from one >of the partitions and then drop the partition and create more new >partitions >with different partition filters. After I have created the new partitions >I >want to reload the unloaded data rows and have them inserted into the new >correct partitions. > >If I understood the system better I would probably just recreate all the >tables with partitions as tables with a single partition. But I don't want >to change too much and I really don't have the time for that. > >If there are any Oracle experts who can help point me in the right >direction >I would really appreciate it. This would be so easy in Informix and I'm at >a loss for how to do it with Oracle. :) > >BTW... a potential area of concern is that some of the partitioned tables >haves columns with the RAW data type. I would want to make sure that after >I dump the RAW data it will be restored correctly when the data is >reloaded. > >Thanks, >Gregg Walker > > sending to informix-list

Tsutomu Ogiwara wrote: > Hi Gregg. > > Just my $0.02. > > My experience, I used SQLDA via Pro*C. > You can find sample program somewhere. > > Regards. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 I would too ... but only if I was being paid by the hour. ;-) What you suggest is one of the most difficult ways I can imagine to do a very simple administrative task. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)