Re: SQL Loader Control File Generation

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 16 Jul 1999 08:35:18 -0400
Message-ID: <7mn8st$9i$1@autumn.news.rcn.net>

Okay,

    What is TFTS and what sort of scripts are generated?

    If you are talking about scripts that will generate the control file for a table check out some of the Oracle sites that have scripts and look for Jared Still's sqlunload script. It generates the control file and dumps the table to a flat file.

    You can always do a select against USER_TABLES, spool the output, and then execute it from SQL*Plus. For example,

    SPOOL sqlunloader.sql
    SELECT '@sqlunld', table_name FROM user_tables;     SPOOL off

    @sqlunloader

will create a sql script that when executed will run a sql script named sqlunld for each table belonging to the user and then run that script. This will work for both NT and Unix.

regards
Jerry Gitomer

---

---

James Varga wrote in message
<7mmqd4$7fc$1_at_news1.cableinet.co.uk>...
>I was wondering if I could get some assistance. I am fairly new
to
>prodecural SQL and was hopping to amend the SQL Loader control
file
>generation script in TFTS to cycle through all tables for a
user. I know
>this may sound like a really simple query, but any help would be
great.
>
>
>
>
Received on Fri Jul 16 1999 - 07:35:18 CDT