From: Shakespeare <>
Date: Thu, 20 Nov 2008 22:21:38 +0100
Message-ID: <4925d4ea$0$190$>

sybrandb schreef:
> On 20 nov, 11:21, Ismael <> wrote:

>> On Nov 20, 10:14 am, sybrandb <> wrote:
>>> On 20 nov, 09:14, Ismael <> wrote:
>>>> Hi,
>>>> Oracle on Win 2003 Server
>>>> We have an Oracle database running in automatic undo management.
>>>> An application provider has to upgrade his application and needs the
>>>> database running in manual undo management.
>>>> I've never gone back to manual from auto ... could you give me any
>>>> advice? Do you know the best way to success?
>>>> Thank you very much for your help?
>>>> Best Regards,
>>>> Ismael
>>> I would request the 'application' provider to send his 'developers' to
>>> a course, so the 'application' doesn't need to walk on one leg and one
>>> crutch.
>>> --
>>> Sybrand Bakker
>>> Senior Oracle DBA
>> One of the migration steps is the repository upgrade (the repository
>> is stored in the oracle database). For this step, they advise us to
>> change de undo management to MANUAL before running the processes that
>> are involved. It's not an application requirement, we can change to
>> AUTO after upgrading ...
>> Changing undo management to MANUAL is ONLY for the upgrade.
>> Could you help me?- Tekst uit oorspronkelijk bericht niet weergeven -
>> - Tekst uit oorspronkelijk bericht weergeven -

> The obvious solution is of course to take the documentation and to
> read up on undo management,
> and to notice you only need to create rollback segments and change the
> undo_management parameter.
> As this would have required you to do work, which you rather avoid,
> you are asking a volunteer to abstract the docs.
> Current DBA mentality is so sad....
> --
> Sybrand Bakker
> Senior Oracle DBA

Luckily we still have our senior DBA's.....

What's in a RAID?? Received on Thu Nov 20 2008 - 15:21:38 CST

Original text of this message