joel garry wrote:
> On Nov 7, 8:08 am, GS <G..._at_GS.com> wrote:
>
>> 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?
>
> Search for DBUA at tahiti.oracle.com. You will find 1 entry for XE
> which explains that you need to patch it. I learned something new
> today, I was still under the impression there weren't patches for XE.
> I hadn't really been paying attention.
>
> It also mentions the utility is for going from XE to 10g, so you have
> to exp/imp anyways.
>
> I've habitually used exp/imp, but mostly because every upgrade I've
> done has involved something that made it the way to go. Haven't done
> it with production XE though.
>
> jg
> --
> @home.com is bogus.
> The largest export from the US to the People's Republic of China is
> dollars.
>
>
>
Thanks - exp/imp is the way I'll go anyway, its a small enough
database its probably the fastest route anyway
Received on Wed Nov 07 2007 - 15:49:55 CST
