Loading tables?

From: venkat Rama <techsqlca_at_yahoo.com>
Date: Thu, 17 Jul 2003 18:36:01 -0700 (PDT)
Message-Id: <25946.338348@fatcity.com>

--0-16210155-1058492161=:68491
Content-Type: text/plain; charset=us-ascii

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! --0-16210155-1058492161=:68491
Content-Type: text/html; charset=us-ascii

<DIV>Hi Friends,</DIV>
<DIV> </DIV>
<DIV>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??</DIV>
<DIV> </DIV>
<DIV>TIA</DIV>
<DIV>venkat.</DIV><p><hr SIZE=1>

Do you Yahoo!?<br>
<a href="http://pa.yahoo.com/*http://rd.yahoo.com/evt=1207/*http://promo.yahoo.com/sbc/">SBC Yahoo! DSL</a> - Now only $29.95 per month!
--0-16210155-1058492161=:68491-- Received on Thu Jul 17 2003 - 20:36:01 CDT