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

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

Post by TimeVest In » Fri, 16 Jan 1998 04:00:00



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

 
 
 

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

Post by Gerhard Moell » Sat, 17 Jan 1998 04:00:00



>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.
--

                                      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

 
 
 

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

Post by LMS Configuration Manage » Sat, 17 Jan 1998 04:00:00


Hopefully someone has a better solution, but what I am
using is:

        SPOOL datafile.txt
        SELECT * FROM <TABLE_NAME>;
        SPOOL OFF
        SPOOL ld_<table_name>_ctl.ctl
        DESC <TABLE_NAME>
        SPOOL OFF

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 :-)

Regards

Jerry


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

--
Jerry Gitomer               Since I know how to spell DBA I is one!


 
 
 

1. putting SQL*plus into PL/SQL?

?? 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)
                                WASTIT

                                        (I'm afraid of no SPAM)

2. mac/windows database?

3. Easy to see, hard to put in SQL

4. How to get value from dll file ?

5. How to put Subscript ,Superscript,fractions (1/3,3/4,1/2) in sql

6. Ignore Dup Key Causes Procedures To Fail

7. Best Tool to Put SQl Server on the NET

8. NJ Web Developer Wanted

9. Max Through put out of sql server

10. SQL puts huge bak file in backup folder?

11. Putting sql server 2000 database objects under VSS Source Control

12. PUTTING a SQL DB on CD

13. SQL 7 config -Where put logs?