|
or use insert into select from @dblink ..for main
table and
then update with a subqeury .
Just an option. can be better then flat file
approach .
-ak
----- Original Message -----
Sent: Thursday, July 17, 2003 7:34
PM
Subject: Loading tables?
Hi Friends,
I want to merge some 30 financial tables's data and dump into 3 Big
tables!! What is the best way of doing it?? Can I export all 30 financial
tables and import into one?? looks like dumb question!! May be sql loader? Oh
no! lot of delimitors in control file?? My table had 70 or 80 columns, I feel
its tedious work. By the way Can I append all 30 tables into one txt file and
load into 3 different tables??
TIA
venkat.
Do you Yahoo!?
SBC
Yahoo! DSL - Now only $29.95 per month!
|
