Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 9.2.0.6 to XE - can DBUA do this or better using exp/imp?
Having never used XE I thought perhaps someone here may have done this
and save me some digging. I need to put several databases in remote
locations that will connect via dblink to a main database here. As of
today the main database is on 9.1.0.7 and the remote database will just
hold a small subset of the data from the main. Adding these databases
will put me close to or over (still have to check) my processor limit
for the amount of named users we have, so I am thinking why not put
these on XE, since they only have an SGA of 800mb and the data they need
to hold is well under 1gb.
Since there is one existing remote machine currently running 9iR2, I was thinking of giving the Oracle upgrade assistant a try, typically I've not had a lot of success with this (from 8.x to 8i, 8i to 9i) and have always used exp/imp.
Does XE even have a utility for this?, or should I just stick with exp/imp?
tia.. Received on Wed Nov 07 2007 - 10:08:29 CST
![]() |
![]() |