Re: Load/unload utilities

From: Bricklen <bricklen_at_shaw.ca>
Date: Sun, 31 Mar 2002 21:05:59 GMT
Message-ID: <3CA77969.318429CC_at_shaw.ca>


I'm getting this strange feeling that you work for the company that developed Unicenter...

;-)

Nicole wrote:
>
> 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 - 23:05:59 CEST

Original text of this message