Re: 8i-10g upgrade

Hello

I researched streams extensively just last week and it does not copy the existing data.
You need to create a new database that is a copy of the current database, using expdp/impdp or rman, and then streams will keep them the same.

Adar Yechiel
Rechovot, Israel

Bort, Guillermo wrote:
>
> Hi everyone,
>
>
>
> We have a 10g database with over 3.5 TB of data. This supports a
> SAPR3 application. However, this database has been upgraded twice
> since it was originally created and the upgrade went from 8i to 9i to
> 10gr2. It has come to be somewhat unmanageable since It's so big and
> most tablespaces are 'Dictionary Managed' (thanks 8i). We have been
> trying to solve this by migrating the tablespaces to locally managed,
> but there are a couple of tablespaces that are humongous and simply
> there is not enough time during a weekend to do this change. CT cannot
> tolerate any more downtime. At this point we are drawing a blank... so
> I thought I could ask over here, perhaps someone has a little
> experience with these sort of issues.
>
>
>
> I considered creating a second database (which would require about
> 3.5 TB of temporary storage), and using streams or datapump to move
> all the data... however I never implemented streams in this way and am
> not certain it could be done.
>
>
>
> Thanks in advanced.
>
>
>
> *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.
>
>
>

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