--=_7f48dfc2a1e903179e9bab23363726f3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"
But do we link oracle trigger to postgres trigger ?
i mean :
oracle trigger will take a note of what has been changed .
but then how do we pass those changes to postgres trigger ?
can u suggest any logic or algorithm ?
Regards,=20
Srikanth k Potluri=20
+63 9177444783(philippines)=20
On Sat 26/04/08 8:40 PM , "Joshua D. Drake" jd@[EMAIL PROTECTED]
Adonias Malosso wrote:=20
> Hi All,=20
> =20
> I=EF=BF=BDd like to know what=EF=BF=BDs the best practice to LOAD a 70
m=
ilion
rows, 101 =20
> columns table=20
> from ORACLE to PGSQL.=20
> =20
> The current approach is to dump the data in CSV and than COPY it
to =20
> Postgresql.=20
> =20
> Anyone has a better idea.=20
Write a java trigger in Oracle that notes when a row has been =20
added/delete/updated and does the exact same thing in postgresql.=20
Joshua D. Drake=20
> =20
> =20
> Regards=20
> Adonias Malosso=20
-- =20
Sent via pgsql-performance mailing list
(pgsql-performance@[EMAIL PROTECTED]
[1])=20
To make changes to your subscription:=20
http://www.postgresql.org/mailpref/pgsql-performance=20
Links:
------
[1]
http://sitemail7.hostway.com/javascript:top.opencompose(\'pgsql-performance=
@[EMAIL PROTECTED]
',\'\',\'\',\'\')
--=_7f48dfc2a1e903179e9bab23363726f3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="utf-8"
<HTML>
But do we link oracle trigger to postgres trigger ?<br>
<br>
i mean :<br>
<br>
oracle trigger will take a note of what has been changed .<br>
but then how do we pass those changes to postgres trigger ?<br>
<br>
can u suggest any logic or algorithm ?<br>
<br>
<br>
<br>
Regards,
<br>
Srikanth k Potluri
<br>
+63 9177444783(philippines) <br>
<br>
<span style=3D"font-weight: bold;">On Sat 26/04/08 8:40 PM , "Joshua D.
Dr=
ake" jd@[EMAIL PROTECTED]
sent:<br>
</span><blockquote style=3D"border-left: 2px solid rgb(245, 245, 245);
marg=
in-left: 5px; margin-right: 0px; padding-left: 5px; padding-right:
0px;">Ad=
onias Malosso wrote:
<br>
<span style=3D"color: red;">> Hi All,
</span><br>
<span style=3D"color: red;">>=20
</span><br>
<span style=3D"color: red;">> I=EF=BF=BDd like to know what=EF=BF=BDs
th=
e best practice to LOAD a 70 milion rows, 101=20
</span><br>
<span style=3D"color: red;">> columns table
</span><br>
<span style=3D"color: red;">> from ORACLE to PGSQL.
</span><br>
<span style=3D"color: red;">>=20
</span><br>
<span style=3D"color: red;">> The current approach is to dump the data
i=
n CSV and than COPY it to=20
</span><br>
<span style=3D"color: red;">> Postgresql.
</span><br>
<span style=3D"color: red;">>=20
</span><br>
<span style=3D"color: red;">> Anyone has a better idea.
</span><br>
<br>
Write a java trigger in Oracle that notes when a row has been=20
<br>
added/delete/updated and does the exact same thing in postgresql.
<br>
<br>
Joshua D. Drake
<br>
<br>
<br>
<span style=3D"color: red;">>=20
</span><br>
<span style=3D"color: red;">>=20
</span><br>
<span style=3D"color: red;">> Regards
</span><br>
<span style=3D"color: red;">> Adonias Malosso
</span><br>
<br>
<br>
--=20
<br>
Sent via pgsql-performance mailing list (<a
href=3D"javascript:top.opencomp=
ose('pgsql-performance@[EMAIL PROTECTED]
','','','')">pgsql-performance@[EMAIL PROTECTED]
>)
<br>
To make changes to your subscription:
<br>
<a target=3D"_blank"
href=3D"parse.php?redirect=3Dhttp%3A%2F%2Fwww.postgres=
ql.org%2Fmailpref%2Fpgsql-performance"><span style=3D"color:
red;">http://w=
ww.postgresql.org/mailpref/pgsql-performance</span></a>
<br>
<br>
</blockquote><BR></HTML>
--=_7f48dfc2a1e903179e9bab23363726f3--
|
