Re: sql*loader puts in in, how do I put it out

reb_at_shell5.ba.best.com (TimeVest Inc.) wrote:

>What command do I use to OUTPUT a database into a format that can
>be easily used by SQL*Loader?

If you want to export a Oracle database to import it again in Oracle (either in some other instance or some other user scheme), you use the Oracle Export and Import tools. They are described in the same Manual as SQL*Loader is. (Utilities).

The are quite trivial to use, in general you just type

        exp <username>/<passwd>
for an interactive export session, and

        imp <username>/<passwd>
for an interactive import session.

        exp help=y
and

        imp help=y
will give you help screens.

        Gerhard.

-- 
Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
                                      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