Re: 10g upgrade survey

Williams,

You have missed another option of upgrade from 9i to 10g, i.e., transportable tablespaces. I know in 9i, it only works on the same OS. If you are going to upgrade 9i database to 10g, transportable tablespace option also very handy. As 9i datafile are 10g compartible, it can be done with minimal downtime as well.

1. Install 10g on the target, create db with all the users
2. On source, bring all the tablespace to read only mode.
3. Export with transportable tablespaces.
4. move all the datafiles from source to target (this is only the time consuming process)
5. Import at target.

We have done with couple of database where it took very minimal downtime.

Of course, you need to see the possibilties and all the aspect before you choose any method.

We have also done in-place upgrade (manual upgrade).

Jaffar

On 3/5/07, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> List,
>
> If you've upgraded more than one database to 10g, please let me know what
> method you chose:
>
> 1. dbua
> 2. Manual upgrade
> 3. Created a 10g database and migrated the data.
>
> Either reply to the list or to me directly. Also please let me know why
> you chose the path you selected and if you had to do it again if you'd done
> it differently.
>
> Thanks,
> Dennis Williams
>

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

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