demo@P4P > select ENDIAN_FORMAT, PLATFORM_NAME from v$transportable_platform
2 order by 1; Big HP-UX IA (64-bit) Big Solaris[tm] OE (32-bit) Big Apple Mac OS Big HP-UX (64-bit) Big IBM zSeries Based Linux Big AIX-Based Systems (64-bit) Big Solaris[tm] OE (64-bit) Big IBM Power Based Linux Little Solaris Operating System (x86) Little Microsoft Windows 64-bit for AMD Little Linux 64-bit for AMD Little Microsoft Windows IA (64-bit) Little HP Open VMS Little HP Tru64 UNIX Little Linux IA (32-bit) Little Microsoft Windows IA (32-bit) Little Linux IA (64-bit) So you look ok...You could use tts or export, you could probably also check on using rman duplicate to another host
http://www.oracle-base.com/articles/9i/DuplicateDatabaseUsingRMAN9i.php Good Luck! Bob David Sharples wrote:
he has 9i not 10g where NONE of that is possible On 15/11/06, *Bob* <orcl@xxxxxxxxxxx <mailto:orcl@xxxxxxxxxxx>> wrote: Hi Anurag This is called "Platform Migration" High level overview The source database needs to be the same version as the target If the Endian is the same for each platform then you useTTS If the Endian is different, you need RMAN to convert the datafiles along with TTS NFS mounts of the target are a big help and could be quicker (& more logical) than FTP Anurag Verma wrote:Hi All,Can we move a Oracle 9i (9.2.0.7 <http://9.2.0.7/>) database froma Solaris 9(64 bit server) server to an AIX 5.2 (64 bit) server, by using RMAN backup/restore/recovery??Anurag
-- "Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."