|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Laplink Gold 2008 - $15 Off with Coupon Code CJM9NE
|
|
#1
January 30th, 2004, 04:34 AM
|
|||
|
|||
|
Porting Oracle Data
I want to Copy Two Oracle tables from database in one PC to another Database in different PC. Is there anyway I can do that Programatically So that i can do that on a regular Basis without DBA's help.
|
|
#2
January 30th, 2004, 07:14 AM
|
||||
|
||||
|
You can ask your dba to put up a dblink to connect the two databases.
With it you can issue queries like: SELECT ... FROM schema.table@dblink
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) Understanding SQL Joins An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Porting Oracle Data |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
