Home » RDBMS Server » Server Utilities » Copy data from one DB to another (Oracle 9i)
Copy data from one DB to another [message #447431] Mon, 15 March 2010 05:05 Go to next message
shadab
Messages: 4
Registered: August 2009
Location: india
Junior Member
Hi,

we have a prod DB and an Backup DB..
I have been asked to copy selected tables from prod Db to anaylsis DB on a weekly basis. Db version is 9i.

Can I use Db links here?, but the data is huge.

Please help me, hw to approach towards this..Examples would be appreciated.


please let me know any further details required.
Re: Copy data from one DB to another [message #447441 is a reply to message #447431] Mon, 15 March 2010 05:39 Go to previous message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
export/import.
See Database Utilities

Regards
Michel
Previous Topic: ORA-39127:
Next Topic: using decode in SQL*Loader
Goto Forum:
  


Current Time: Sat Sep 24 23:10:05 CDT 2016

Total time taken to generate the page: 0.09636 seconds