Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: to XE - can DBUA do this or better using exp/imp?

Re: to XE - can DBUA do this or better using exp/imp?

From: GS <>
Date: Wed, 07 Nov 2007 21:49:55 GMT
Message-ID: <7qqYi.32127$XF6.9012@edtnps90>

joel garry wrote:
> On Nov 7, 8:08 am, GS <> 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 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 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
> --
> 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

Original text of this message