Hi,

I did this a couple of weeks ago, and a wonderful little utility called "rconfig" that comes with 10gR2 made light work of it. Like all automated tools it was not perfect (the datafile names after migration were not exactly what I would call "human readable"), but I migrated Oracle's "Vision Demo" database (E-Business Suite) from 9iR2 Standalone to 10gR2 RAC with ASM. Oracle was even kind enough to document the process with a Metalink Note.

Anyway, the migration was pretty quick (90 minutes for the 65Gb database), and with 10gR2 you can use all those wonderful features like Native PL/SQL Code to speed things up a bit.

Enjoy!

Paul

*********** ORIGINAL MESSAGE ***********

On 28/04/2006 at 11:50 PM YIF wrote:

Dear All
I’m in the process of upgrading our Oracle 9i Standalone database to
Oracle 10R2 RAC.
Has anyone upgraded to 10g and had some issues, one of my plans is to go
with Locally Managed Tablespaces.
large Block Size.
Export from 9i and Import it in the new 10g Cluster

We have 32 applications using our existing database, those apps heavily
using Packages ,Stored Procedures, Functions and Triggers.
Will there be any migration issues on 10g.

Any input will be highly appreciated

Regards




///\\
(@ @)
+--oOO--(_)--Ooo--+
|Yoseph I Fahed|
+-----------------+
|__|__|
|| ||
ooO Ooo




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page