RE: 8i-10g upgrade
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- Date: Fri, 28 Nov 2008 09:50:51 -0600
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@xxxxxxx <mailto:name.name@xxxxxxx>
We deliver on our commitments
so you can deliver on yours.
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
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@xxxxxxx> 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@xxxxxxx <mailto:name.name@xxxxxxx>
We deliver on our commitments
so you can deliver on yours.
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
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@xxxxxxx> 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.'
Other related posts:
