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: POPULATING DATA OVER A DATABASE LINK USING A SEQUENCE TABLE

RE: POPULATING DATA OVER A DATABASE LINK USING A SEQUENCE TABLE

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Wed, 3 Nov 2004 13:45:43 -0500
Message-ID: <E518A02B320C8D4E97D99A8C546480210251BF6D@dohsmailhq01.doh.ad.state.fl.us>


I am reading that IPC is deprecated in 9i +

=20

-----Original Message-----

From: Igor Neyman [mailto:ineyman_at_perceptron.com]=20 Sent: Wednesday, November 03, 2004 1:34 PM To: Stankus, Paula G; tim_at_sagelogix.com; oracle-l_at_freelists.org Subject: RE: POPULATING DATA OVER A DATABASE LINK USING A SEQUENCE TABLE

Can't you use IPC protocol for your db link?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Wednesday, November 03, 2004 1:12 PM To: tim_at_sagelogix.com; oracle-l_at_freelists.org Subject: POPULATING DATA OVER A DATABASE LINK USING A SEQUENCE TABLE

Guys,

Is there anyway to make this process faster? We are migrating data into one database instance using a sequence table from another database instance. Apparently, the performance has been very slow. I know I had done this on another system years ago but was wondering if anyone had any advice to speed this up. In this case both the databases are on one machine. However, they are using the database link over TCP/IP. I was thinking that there was a way to avoid using the link over TCP/IP if they databases were on the same box. =3D20

Thanks,
Paula
--

http://www.freelists.org/webpage/oracle-l

BEGIN-ANTISPAM-VOTING-LINKS



NOTE: This message was auto-learned as non-spam. If this is wrong, please correct the training as soon as possible. Teach CanIt if this mail (ID 14719808) is spam: Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D14719808&m=3Dd5f9= 4e84d
729
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D14719808&m=3Dd5f9= 4e84d
729
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D14719808&m=3Dd5f9= 4e84d
729

END-ANTISPAM-VOTING-LINKS
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 03 2004 - 12:41:27 CST

Original text of this message

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