Home » SQL & PL/SQL » SQL & PL/SQL » dblink (oracle 10g)
icon10.gif  dblink [message #419582] Mon, 24 August 2009 06:28 Go to next message
Messages: 6
Registered: July 2009
Junior Member
Hi Experts!!!!
Can anyone tell me what is the maximum limit of data that can be transfered through dblink between 2 databases. my databases are of size 40 gb , and the data transfer will be about 50,000 mb per day.. with peak 1000mb/sec

thanks Laughing
Re: dblink [message #419583 is a reply to message #419582] Mon, 24 August 2009 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No limit per Oracle but it is likely you don't use the more appropriate solution.

Re: dblink [message #419588 is a reply to message #419582] Mon, 24 August 2009 06:52 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It depends entirely on the network sped between the two boxes.

If your Dbs are 40Gb, how/why are you transfering 50Gb/day between them?
Can you not stick both systems in the same database?
Previous Topic: ORA-01460: unimplemented or unreasonable conversion requested
Next Topic: Need Output in Singel Row
Goto Forum:

Current Time: Sat Aug 19 21:12:05 CDT 2017

Total time taken to generate the page: 0.45022 seconds