Re: Load/unload utilities

From: Nicole <nsj10_at_hotmail.com>
Date: 31 Mar 2002 08:54:58 -0800
Message-ID: <a9e0e9fb.0203310854.6407ac4c_at_posting.google.com>


[Quoted] You may wish to checkout Unicenter Fast Unload from www.ca.com.

damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C7E67AC.C575300D_at_ci.seattle.wa.us>...
> What is file delimitation? If you can provide a complete explanation ...
> I'm sure we can tell you how to do it.
>
> But I can tell you that Oracle export/import has nothing to do with
> exporting and importing data. It is a tool for backing up and restoring or
> moving data and tables. Likely you will want to look at SQL*Loader,
> UTL_FILE, DBMS_LOB, and DBMS_UTILITY.COMMA_TO_TABLE and
> DBMS_UTILITY.TABLE_TO_COMMA for the functionality you seek.
>
> Daniel Morgan
>
>
>
> "Qaraguli, Waseem [QUAL:C923:EXCH]" wrote:
>
> > Is there equivalent functionality in Oracle to Informix's LOAD/UNLOAD
> > SQL commands that allows for file delimitation? It appears that Oracle
> > does not support this command!!!
> >
> > Can someone point me to the docs that deal with Oracle export/import
> > tools for delimited files.
> >
> > Thanks,
> > Waseem Qaraguli
Received on Sun Mar 31 2002 - 18:54:58 CEST

Original text of this message