Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Loading tables?

Re: Loading tables?

From: AK <oramagic_at_hotmail.com>
Date: Fri, 18 Jul 2003 12:45:55 -0700
Message-Id: <25956.338518@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_03AD_01C34D2A.87605B30 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

or use insert into select from @dblink ..for main table and=20 then update with a subqeury .
Just an option. can be better then flat file approach . -ak

  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! ------=_NextPart_000_03AD_01C34D2A.87605B30 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>or use insert into select from @dblink =
..for main=20
table and </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>then update with a subqeury =
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Just an option. can be better then flat =
file=20
approach .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Dtechsqlca_at_yahoo.com =
href=3D"mailto:techsqlca_at_yahoo.com">venkat Rama</A>=20   </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, July 17, 2003 = 7:34=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Loading tables?</DIV>
  <DIV><BR></DIV>
  <DIV>Hi Friends,</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>I want to merge some 30 financial tables's data and dump =
into&nbsp;3 Big=20
  tables!! What is the best way of doing it?? Can I export all 30 = financial=20
  tables and import into one?? looks like dumb question!! May be sql = loader? Oh=20
  no! lot of delimitors in control file?? My table had 70 or 80 columns, = I feel=20
  its tedious work. By the way Can I append all 30 tables into one txt = file and=20
  load into 3 different tables??</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>TIA</DIV>
  <DIV>venkat.</DIV>
  <P>
  <HR SIZE=3D1>

  Do you Yahoo!?<BR><A=20
  =
href=3D"http://pa.yahoo.com/*http://rd.yahoo.com/evt=3D1207/*http://promo= .yahoo.com/sbc/">SBC=20
  Yahoo! DSL</A> - Now only $29.95 per month!</BLOCKQUOTE></BODY></HTML> Received on Fri Jul 18 2003 - 14:45:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US