What command do I use to OUTPUT a database into a format that can
be easily used by SQL*Loader?
The are quite trivial to use, in general you just type
for an interactive export session, and
for an interactive import session.
will give you help screens.
ICQ PIN: 2804938
OFFIS | | | | | | Tel.: 0441/9722-122
Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102
Hopefully someone has a better solution, but what I am
SELECT * FROM <TABLE_NAME>;
I then edit the ld_<table_name>.ctl file into a real .ctl file for
use by SQL*Loader. It can get tedious when dealing with tables that
have a lot of rows, but it does get the job done :-)
> What command do I use to OUTPUT a database into a format that can
> be easily used by SQL*Loader?
?? Howdy news fans.
Would anyone know haw to embed a SQL*plus command into PL/SQL. Specifically
how do you get it to run SQL*plus and run a spool command in it to put a
query into a file. ??
THX in advance (I do not exist)
(I'm afraid of no SPAM)