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.
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.
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
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)