Re: Help w/ SQL*Loader

From: Joseph Y. Suh <dbtech_at_inetnow.net>
Date: 1996/08/13
Message-ID: <32114395.7509_at_inetnow.net>#1/1

Robert D. Rinehart wrote:
>
> I'm trying to load data from ~30 tables into existing tables (many w/
> 30 fields and some over 50 (yes it's normalized :) )) using a
> SQL*Loader control file.
>
> Is there any way to create the control file interactively (GUI or
> other) to specify datatypes for each column and not have to manually
> type the entire thing?
>
> please reply to bobr_at_endata.com
>
> Thanks in advance
>
> Bob

You may use ' select colum_name, data_type

              from user_tab_columnes
              where table_name='your_table_name'; '

   from user data dictionary, then spool it.

Joseph Suh
Oracle DBA
DB Technology, Inc.
Atlanta, Ga
dbtech_at_inetnow.net.usa Received on Tue Aug 13 1996 - 00:00:00 CEST