Re: SQL Loader for multiple tables?

Some points to consider:

1. Do you have to obey foreign key constraints?
2. How large are your tables?
3. How often will you do this job or a similar one?

Remember that you can load multiple tables from one file by sqlloader! Therefore, it may be preferable to have your format 2) because you may load the interesting parts and drop the uninteresting ones.

Martin Haltmayer

Gary G wrote:
>
> Hi,
> I'm facing a situation where I have data coming to me in two possible ways:
> 1) Each table in separate file, coma delimited, enclosed in quotes
> 2) All tables in one file, coma delimited, enclosed in quotes, separated by
> "INSERT INTO" or some other clause....
>
> What would be a best approach to load above into into DB? I can't seem to
> figure out the syntax for above, or wether its possible at all.....sure hope
> it is. I can't imagine that there is no better way of doing rather one
> table at a time.
>
> About 300 tables
> Oracle 7.3.3/NT 4
> Thanks,
> Gary Gorbonosov
> tolimits_at_pil.net
> /* Comment your code & nobody gets hurt */
  Received on Tue Feb 10 1998 - 00:00:00 CST