Re: Moving schema from 10g on Windows to 10g AIX 5L?

From: Denny Koovakattu <oracle-l_at_koovakattu.com>
Date: Tue, 11 Oct 2005 12:20:06 -0500
Message-ID: <1129051206.434bf44632436@webmail.koovakattu.com>

For a one time copy, you could in theory (haven't tried it) create a new 10g instance on the source, use TTS to plugin the tablespace to that instance and then move it across platforms.

Regards,
Denny

--
Denny Koovakattu


Quoting Yechiel Adar <adar76_at_inter.net.il>:



> Sorry to disappoint you.

> TTS across platforms need source and target at version 10.

> for RMAN:

> Both source and destination databases must be running with

> initialization parameter |COMPATIBLE| set to 10.0 or higher.

>

> Adar Yechiel

> Rechovot, Israel

>

>

>

> Gogala, Mladen wrote:

>

> > if I can convert 9.2 tablespace from Solaris into 10g (10.2.0.1 on RH

> > EL 4.0) but I am not allowed to try it before. So, I am in the

> > catch-22 situation. Do I stand a chance or is my idea completely

> > outlandish and

> >

> > unrealistic?

> >

> > --

> > Mladen Gogala

> > Ext. 121

> >

> >

> >

> >

>

> --

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

>





----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

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

Received on Tue Oct 11 2005 - 12:23:22 CDT