RE: 8i-10g upgrade

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 <mailto: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 <mailto: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