> This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
--B_3292046015_67575
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
Yep =AD just do something like this within sqlplus (from
http://www.dbforums.com/showthread.php?t=3D350614):
set termout off
set hea off
set pagesize 0
spool c:\whatever.csv
select a.a||','||a.b||','||a.c
from a
where a.a=3D"whatever";
spool off
COPY is the fastest approach to get it into PG.
- Luke
On 4/26/08 6:25 AM, "Adonias Malosso" <malosso@[EMAIL PROTECTED]
> wrote:
> Hi All,
>=20
> I=B4d like to know what=B4s the best practice to LOAD a 70 milion rows,
101
> columns table=20
> from ORACLE to PGSQL.
>=20
> The current approach is to dump the data in CSV and than COPY it to
> Postgresql.
>=20
> Anyone has a better idea.
>=20
>=20
> Regards
> Adonias Malosso
>=20
--B_3292046015_67575
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: [PERFORM] Best practice to load a huge table from ORACLE to
PG</=
TITLE>
</HEAD>
<BODY>
<FONT SIZE=3D"4"><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN
STYLE=3D'font-siz=
e:14pt'>Yep – just do something like this within sqlplus (from <a
href=
=3D"http://www.dbforums.com/showthread.php?t=3D350614):">http://www.dbforums.com=
/showthread.php?t=3D350614):</a><BR>
<BR>
</SPAN></FONT></FONT><FONT FACE=3D"Courier, Courier New"><SPAN
STYLE=3D'font-si=
ze:10pt'>set termout off<BR>
set hea off<BR>
set pagesize 0<BR>
<BR>
spool c:\whatever.csv<BR>
<BR>
select a.a||','||a.b||','||a.c<BR>
from a<BR>
where a.a=3D"whatever";<BR>
<BR>
spool off<BR>
</SPAN></FONT><FONT SIZE=3D"4"><FONT FACE=3D"Verdana, Helvetica,
Arial"><SPAN S=
TYLE=3D'font-size:14pt'><BR>
COPY is the fastest approach to get it into PG.<BR>
<BR>
- Luke<BR>
<BR>
On 4/26/08 6:25 AM, "Adonias Malosso" <malosso@[EMAIL PROTECTED]
>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE=3D"4"><FONT FACE=3D"Verdana,
Helvet=
ica, Arial"><SPAN STYLE=3D'font-size:14pt'>Hi All,<BR>
<BR>
I´d like to know what´s the best practice to LOAD a 70 milion
r=
ows, 101 columns table <BR>
from ORACLE to PGSQL. <BR>
<BR>
The current approach is to dump the data in CSV and than COPY it to
Postgre=
sql.<BR>
<BR>
Anyone has a better idea.<BR>
<BR>
<BR>
Regards<BR>
Adonias Malosso<BR>
<BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>
--B_3292046015_67575--
|
