Bill,

I won't try to tell you what is the best method, but I do know that
export/import will work. Export the database with the 9.2 exp utility and
import it with the 10.x imp utility. I don't think copying datafiles will
work in this case, either.

Mark


----- Original Message -----
From: "Bill Zakrzewski "
<oracledba-ezmlmshield-x91028992.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, February 27, 2007 12:29 PM
Subject: Copying Oracle 9.2.0.6.0 DB to Oracle 10.2.0.x DB


> DBAs -
>
> We have an existing production database running Oracle 9.2.0.6.0 and a
> second database in another location running 10.2.0.x (it will probably
> be release 2). What is the best method of copying the entire 9.2.0.6.0
> database to the 10.2.0.x database? Any help will be greatly appreciated?
>
>
> My past experiences make me believe that I can not just copy all of the
> datafiles and open the database (at least not as a 10.2.0.x database).
> Also from past experiences, will I be able to import the 9.2.0.6.0
> export directly into the 10.2.0.x database?
>
>
> TIA
> Bill
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



Oracle LazyDBA home page