Re: Load/unload utilities

In Oracle if no processing logic is required (such as selecting from another table and mixing and matching values) you would use SQL*Loader. It can easily do what you ask. If processing logic is required I would either use SQL*Loader with a procedure or trigger or UTL_FILE depending on the specific requirement.

But SQL*Loader is likely the tool you are looking for. It is installed in the oracle\ora81\bin directory as part of the normal installation and is likely an executable with the name SQLLDR.

Daniel Morgan

"Qaraguli, Waseem [QUAL:C923:EXCH]" wrote:

> The LOAD statement is used to insert data from an operating-system file into
> an existing table and the DELIMITER clause specifies the delimiter that
> separates the data contained in each column in a row in the LOAD FROM file.
> The syntax for the load command is as follows:
>
> LOAD FROM ' filename'
> DELIMITER 'delimiter'
> INSERT INTO 'table_name' (column_names)
>
> This is an example of an input file:
> 0|Jeffery|Padgett|Wheel Thrills|3450 El Camino|Suite 10|PaloAlto|CA|94306||
> 0|Linda|Lane|Palo Alto Bicycles|2344
> University||PaloAlto|CA|94301|(415)323-6440
>
> This load functionality is particularly useful when bulk importing data from
> another system, or when exporting data into a tab delimited format for opening
> in MS-Excel for example.
>
> The documentation for the UTL_FILE and DBMS_UTILITY functionality does not
> appear to extend similar delimitation handling. Can you conform.
>
> Waseem Qaraguli
>
> damorgan wrote:
>
> > 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 Thu Feb 28 2002 - 20:44:48 CET