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