Re: SQL Loader Control File Generation

Cheers,

I'll give that a try!

James

Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message news:7mn8st$9i$1_at_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 Sat Jul 17 1999 - 07:08:49 CDT