Re: 8i-10g upgrade

Guillermo,

I would suggest that you create a test database which is an exact clone of this database. A good idea is to create that test database by recovering a backup copy of the production database. Then you can test any of your proposed changes before performing them on production, plus get an idea of how much time they will take.

Oh wait . . . . here it comes . . . management doesn't want to devote enough storage space to let you create a test copy of this database. Sorry that always seems to be the response to the above statement. Actually, since this database holds SAP data, that probably means the uncontrollability of this database threatens the very viability of the organization itself, so they may be more willing to spring for the hardward.

Dennis Williams

On Fri, Nov 28, 2008 at 9:50 AM, Bort, Guillermo <guillermo.bort_at_eds.com>wrote:

> I am sorry, I was still thinking about export/import or
> dbms_redefinition. Yes, migrate_to_local uses only the original tbs, however
> it takes way too long to convert a 1.5TB tbs.
>
>
>
> *Guillermo Alan Bort*
>
> DBA / DBA Main Team
>
>
>
> *EDS*, an HP company
>
> ITO
>
> Arias 1851
>
> Ciudad Autonoma de Buenos Aires (C1429DXC)
>
> Argentina
>
>
>
> Tel: +54 11 4704-3132
>
> E-mail: guillermo.bort_at_eds.com <name.name_at_eds.com>
>
>
>
> We deliver on our commitments
>
> so you can deliver on yours.
>
>
>
> *From:* Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
> *Sent:* Friday, November 28, 2008 1:39 PM
>
> *To:* Bort, Guillermo
> *Cc:* Oracle Mailinglist
> *Subject:* Re: 8i-10g upgrade
>
>
>
> I guess I dont understand? drop the old tablespaces? The
> Tablespace_migrate_to_to_local procedure converts the tablespaces in place
> to locally managed. No old tablespaces need to be dropped, it just converts
> the current tablespaces in place.
>
> On Fri, Nov 28, 2008 at 9:02 AM, Bort, Guillermo <guillermo.bort_at_eds.com>
> wrote:
>
> Actually, it takes quite some time. Plus, because of space limitations, we
> need to drop the old tablespaces, and that takes ages, since they are
> dictionary managed. I'd like to have the database for myself for just 10
> days… but CT is not willing to have that much downtime…
>
>
>
> *Guillermo Alan Bort*
>
> DBA / DBA Main Team
>
>
>
> *EDS*, an HP company
>
> ITO
>
> Arias 1851
>
> Ciudad Autonoma de Buenos Aires (C1429DXC)
>
> Argentina
>
>
>
> Tel: +54 11 4704-3132
>
> E-mail: guillermo.bort_at_eds.com <name.name_at_eds.com>
>
>
>
> We deliver on our commitments
>
> so you can deliver on yours.
>
>
>
> *From:* Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
> *Sent:* Friday, November 28, 2008 12:59 PM
> *To:* Bort, Guillermo
> *Cc:* Oracle Mailinglist
>
>
> *Subject:* Re: 8i-10g upgrade
>
>
>
> I dont recall that running the tablespace migrate to local procedure took
> all that long. How long is it taking to migrate a tablespace?
>
> On Fri, Nov 28, 2008 at 8:21 AM, Bort, Guillermo <guillermo.bort_at_eds.com>
> wrote:
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l