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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
export/import.
See Database Utilities

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 19 07:41:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.