Hi Joe,
It may be my English but I can't understood what do you mean by saying:
> No upgrade in place, etc...
> The first server is Solaris 8 sparc with oracle 9.2.0.5.0, the second, or
> new server will be Solaris 10 sparc with oracle 10.2.0.1.0
In one hand you sad you are not going to upgrade any thing
In the other you are saying you would like to move DB from 9.2 Sol 8
to 10.2 Sol 10.
To me this move looks like upgrade of database and OS, isn't it?
II. Would you like to move a whole database or just part of it?
III. Would you like to move it permanently (just ones) or you will
need to refresh the data time to time in future?
In case you would like just move DB to another server and make DB
version upgrade then I would recommend to make one change at the time:
I ether: upgrade db to 10.2 on your old server then move it to new server.
II ether: move 9.2 db to new server (startup db and make sure that you
completed that step), then upgrade db to 10.2 whatever.
You can try to combine two steps, but you wouldn't know in case of
problems the root of those.
BTW: If your old server is 32 bit and new one is 64 bits you will need
to execute additional steps described in Metalink or Upgrade docs.
PS: As rightly has been said previously. You do not need to do endian
converting in that case.
Yury
On 6/21/06, Joe Smith <joe_dba@(protected):
> I want to move a db from one server to another. I basically have to do it
> this way. No upgrade in place, etc...
>
> The first server is Solaris 8 sparc with oracle 9.2.0.5.0, the second, or
> new server will be Solaris 10 sparc with oracle 10.2.0.1.0
>
> Can I use a combination of transportable tablespaces with converting the
> datafiles with endian format?
>
> thanks.
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar ? get it now!
> http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l
