RE: Informix Unload equivalent in Oracle
> -----Original Message-----
> From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]
> On Behalf Of Obnoxio The Chav
> Sent: 14 January 2005 11:37 AM
> To: Gregg Walker
>
> Gregg Walker said:
> >
> >> If you must do this via an 'unload', look at import and export
> >> (imp/exp).
> >> You could perhaps export Partition X (from Table A), create a new
> >> partitioned table with the new partitions you want, import into
this
> >> table, and then swap these partitions back into Table A.
> >
> > This sounds like a lot of tedious work since I have about 20 tables
that
> > need to have this done.
> >
> >> Although I'm also not really sure why you are unloading the table
at
> all
> >> ?
> >
> > Me either. It's my Informix mentality... :)
>
> Me neither, and I have an Informix mentality too. Haven't you heard of
> alter fragment?
>
Reminds me of another reply often used on this list ..... have you tried
update statistics ? ;-)
sending to informix-list