dbTalk Databases Forums  

9i to 10G (on new server) upgrade - exp/imp the only option?

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss 9i to 10G (on new server) upgrade - exp/imp the only option? in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GS
 
Posts: n/a

Default 9i to 10G (on new server) upgrade - exp/imp the only option? - 05-29-2008 , 05:58 PM






I think I answered the question with the title of this post, but it
leaves me wondering why Oracles upgrade assistant only works if the
database you are upgrading from is on the same machine. I know MS-SQL is
a different beast, but it does effortless upgrades from one machine to
another and the basic premise is the same, except in Oracle you are
moving many schema's over while MSSQL is moving one schema (database)

Or is there another reason Oracle can't do this? Normally exp/imp is no
problem as the ones I have done so far are relatively small, but I am
doing a bigger one now (still small by database standards at 20GB) and
it is DOG SLOW, 2 hours so far and it's only part way through the first
of many schemas I am moving over.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.