Home » RDBMS Server » Server Utilities » copying data from production to archival db (oracle 10.2.0.3 solaris 10 64 bit)
copying data from production to archival db [message #327104] Fri, 13 June 2008 17:14 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Experts,

i got one work. i have a prod db. from there i need to copy 13 months data to archival DB. what could be the best approch to do it?

Report message to a moderator

Re: copying data from production to archival db [message #327106 is a reply to message #327104] Fri, 13 June 2008 17:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>from there i need to copy 13 months data
Depends on how you can identify 13 months of data.
Depends on volume of data.
Depends on source and target databases versions, OS.

Report message to a moderator

Re: copying data from production to archival db [message #327847 is a reply to message #327104] Wed, 18 June 2008 03:41 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
How you will identified data based on 13 months? Is the table partitioned based on date ? or you have date column inside tables.

Report message to a moderator

Previous Topic: SQLLDR doesn't work when last columns are not null
Next Topic: TRACE ANALYZER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:24:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.