Home » RDBMS Server » Server Utilities » data migration (oracle 10g & 11 g)
data migration [message #638170] Fri, 05 June 2015 01:42 Go to next message
simplesanju
Messages: 36
Registered: July 2008
Member
HI All,

Source And destination configuration is given in attachment. Please suggest best approach for data migration.

/forum/fa/12714/0/

options:
• SQL*loader utility
• SQL developer
• Traditional IMP/EXP (which you are using in your attachment)
• SQL*plus COPY command
• Transportable tablespace
• Custom PL/SQL Procedure
• Oracle Data Pump

Thanks
Sanjana

Report message to a moderator

Re: data migration [message #638174 is a reply to message #638170] Fri, 05 June 2015 01:51 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Data pump should be fine with EXPDP on lower version to IMPDP on higher version.

Report message to a moderator

Re: data migration [message #638182 is a reply to message #638174] Fri, 05 June 2015 06:34 Go to previous message
simplesanju
Messages: 36
Registered: July 2008
Member
Thanks for your suggestion lalit.

Report message to a moderator

Previous Topic: KUP-11024: This external table can only be accessed from within a Data Pump job.
Next Topic: Reading multiple text files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 00:42:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.