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
Messages: 4
Registered: August 2009
Location: india
Junior Member

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: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See Database Utilities

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

Current Time: Sun Oct 23 01:21:10 CDT 2016

Total time taken to generate the page: 0.12894 seconds