Re: ENDIAN_FORMAT - little or big of Solaris 8/9 (32/64 bit) & IBM AIX OS?

Byte edian is decide by the hardware platform, you can query it from 10g to decide which platform is big edian or little edian.

On 9/14/05, Powell, Mark D <mark.powell_at_eds.com> wrote:
>
> Oracle did not support movement of datafiles across non-compatible
> hardware until version 10g with the use of rman.
>
> With all lower released you move data using exp, binary ftp, and imp or
> use exp/imp across network.
>
> HTH -- Mark D Powell --
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
> Sent: Tuesday, September 13, 2005 12:16 PM
> To: Oracle-L
> Subject: ENDIAN_FORMAT - little or big of Solaris 8/9 (32/64 bit) & IBM
> AIX OS?
>
>
>
> On my Oracle 8.1.7 & 9.2 databases:-
>
> SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM; Failing with the Error:-
>
> SELECT * FROM V$TRANSPORTABLE_PLATFORM
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> How can the respective view be created / enabled?
>
> Is there any Other way to know the ENDIAN_FORMAT i.e. little or big for
> machines running Solaris 8/9 (32/64 bit) & IBM AIX OS?
>
> Need to know the same to check use of Transportable tablespace movement
> across heterogeneous O.S. with Oracle 9.2
>
> Also assuming the ENDIAN_FORMAT is the same, does Oracle officially
> support the usage of Transportable tablespace to move DB from SUN to AIX
> using Oracle 9.2?
>
> Thanks
>
>
> **************** CAUTION - Disclaimer ***************** This e-mail
> contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the
> use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further,
> you are not to copy, disclose, or distribute this e-mail or its contents
> to any other person and any such actions are unlawful. This e-mail may
> contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as
> a result of any virus in this e-mail. You should carry out your own
> virus checks before opening the e-mail or attachment. Infosys reserves
> the right to monitor and review the content of all messages sent to or
> from this e-mail address. Messages sent to or from this e-mail address
> may be stored on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Welcome, Fangxin.Lou from China
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

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