Re: Load/unload utilities

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 17:23:52 GMT
Message-ID: <3C7E67AC.C575300D_at_ci.seattle.wa.us>

[Quoted] 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 - 18:23:52 CET

This message: [ Message body ]
Next message: damorgan: "Re: Using SQL IN predicate in PL/SQL"
Previous message: Damian Smith: "Re: Tools (toad etc!)"
In reply to Qaraguli, Waseem [QUAL:C923:EXCH]: "Load/unload utilities"
Next in thread: Qaraguli, Waseem [QUAL:C923:EXCH]: "Re: Load/unload utilities"
Reply: Qaraguli, Waseem [QUAL:C923:EXCH]: "Re: Load/unload utilities"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message