SEO

#1 (**permalink**) 02-26-2008, 07:46 AM

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..

#2 (**permalink**) 02-26-2008, 07:46 AM

On Nov 7, 8:08 am, GS <G...@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.

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.

#3 (**permalink**) 02-26-2008, 07:46 AM

On Nov 7, 8:08 am, GS <G...@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.

#4 (**permalink**) 02-26-2008, 07:46 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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