SQL*Loader and multiple tables?
From: Gary G <tolimits_at_pil.net>
Date: 1998/02/04
Message-ID: <6b9sgr$k0o_at_netaxs.com>#1/1
Date: 1998/02/04
Message-ID: <6b9sgr$k0o_at_netaxs.com>#1/1
Hi,
I'm facing a situation where I have data coming to me in two possible ways:
- Each table in separate file, coma delimited, enclosed in quotes
- All tables in one file, coma delimited, enclosed in quotes, separated by [Quoted] "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 Wed Feb 04 1998 - 00:00:00 CET