I changed the COMPATIBLE parameter in the in the init.ora file to 10.2.0.1.0. And it worked fine. But not sure of the reason.
On 11/3/05, Steve Adams <steve.adams@(protected)> wrote: > > Well, that explains it then. You may want to post a followup to the list > to say what the solution was. > > @ Regards, > @ Steve Adams > @ http://www.ixora.com.au/ - For DBAs > @ http://www.christianity.net.au/ - For all > -- --Original Message-- -- > *From:* DBA Deepak [mailto:oracle.tutorials@(protected)] > *Sent:* Thursday, 3 November 2005 9:43 PM > *To:* Steve Adams > *Subject:* Re: Transaport TS error > > It is 9.2.0.0.0 in th einit.ora file. > > On 11/3/05, Steve Adams <steve.adams@(protected)> wrote: > > > > What is the 'compatible' parameter setting on the target database? > > > > @ Regards, > > @ Steve Adams > > @ http://www.ixora.com.au/ - For DBAs > > @ http://www.christianity.net.au/ - For all > > > > -- --Original Message-- -- > > From: oracle-l-bounce@(protected) [mailto: > > oracle-l-bounce@(protected)] On Behalf Of DBA Deepak > > Sent: Thursday, 3 November 2005 9:14 PM > > To: oracle-l@(protected) > > Subject: Transaport TS error > > > > > > Hi All, > > > > I have two DBs DB1 abd DB2 on the same server (W2K, Oracle 10gR2). > > Trying to transport a TS for DB1 to DB2. > > > > Getting the following errors while importing the metadata. > > > > Export file created by EXPORT:V10.02.01 via conventional path > > About to import transportable tablespace(s) metadata... > > import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character > > set > > . importing SYS's objects into SYS > > . importing SYS's objects into SYS > > IMP-00017: following statement failed with ORACLE error 721: > > "BEGIN sys.dbms_plugts.checkCompType('COMPATSG','10.2.0.1.0'); END;" > > IMP-00003: ORACLE error 721 encountered > > ORA-00721 (See ORA-00721.ora-code.com): changes by release 10.2.0.1.0 cannot be used by release > > 9.2.0.0.0 > > ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_PLUGTS", line 2004 > > ORA-06512 (See ORA-06512.ora-code.com): at line 1 > > IMP-00000: Import terminated unsuccessfully > > > > I am not using 9i DB, then why is the error ORA-00721 (See ORA-00721.ora-code.com): changes by > > release 10.2.0.1.0 cannot be used by release 9.2.0.0.0. > > > > Please help... > > > > > > -- > > Regards, > > > > Deepak > > Oracle DBA > > > > > > > -- > Regards, > > Deepak > Oracle DBA >
-- Regards,
Deepak Oracle DBA
I changed the COMPATIBLE parameter in the in the init.ora file to 10.2.0.1.0. And it worked fine. But not sure of the reason.<br><br> <div><span class="gmail_quote">On 11/3/05, <b class="gmail_sendername">Steve Adams</b> <<a href="mailto:steve.adams@(protected)">steve.adams@(protected) .au</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div><span><font face="Arial" color="#0000ff" size="2">Well, that explains it then. You may want to post a followup to the list to say what the solution was. </font></span></div><span class="q"> <p><font size="2">@ Regards,<br>@ Steve Adams<br>@  ; <a onclick="return top.js.OpenExtLink(window,event,this)" href="http:/ /www.ixora.com.au/" target="_blank">http://www.ixora.com.au/</a> - For DBAs<br>@ <a onclick= "return top.js.OpenExtLink(window,event,this)" href="http://www.christianity.net .au/" target="_blank"> http://www.christianity.net.au/</a> - For all </font></p> <div></div></span> <div><span class="e" id="q_107562d5ee4b5ee8_2"> <div lang="en-us" dir="ltr" align="left"><font face="Tahoma" size="2">---- -Original Message-- --<br><b>From:</b> DBA Deepak [mailto:<a onclick="return top .js.OpenExtLink(window,event,this)" href="mailto:oracle.tutorials@(protected)" target="_blank"> oracle.tutorials@(protected)</a>] <br><b>Sent:</b> Thursday, 3 November 2005 9:43 PM<br><b>To:</b> Steve Adams<br><b>Subject:</b> Re: Transaport TS error<br><br> </font></div>It is 9.2.0.0.0 in th einit.ora file.<br><br> <div><span class="gmail_quote">On 11/3/05, <b class="gmail_sendername">Steve Adams</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:steve.adams@(protected)" target="_blank">steve.adams@(protected) </a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">What is the 'compatible' parameter setting on the target database?<br><br>@ Regards,<br>@ Steve Adams <br> @ <a onclick="return top.js.OpenExtLink(window,event,this)" href= "http://www.ixora.com.au/" target="_blank">http://www.ixora.com.au/</a> - For DBAs<br>@ <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www .christianity.net.au/" target="_blank"> http://www.christianity.net.au/</a> - For all<br><br>-- --Original Message-- --<br>From: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l-bounce @(protected) </a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l-bounce@(protected) .org</a>] On Behalf Of DBA Deepak<br>Sent: Thursday, 3 November 2005 9:14 PM <br>To: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto :oracle-l@(protected)" target="_blank">oracle-l@(protected)</a><br>Subject: Transaport TS error<br><br><br>Hi All,<br><br>I have two DBs DB1 abd DB2 on the same server (W2K, Oracle 10gR2). Trying to transport a TS for DB1 to DB2. <br><br>Getting the following errors while importing the metadata.<br><br >Export file created by EXPORT:V10.02.01 via conventional path<br>About to import transportable tablespace(s) metadata...<br>import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set <br>. importing SYS's objects into SYS<br>. importing SYS's objects into SYS<br >IMP-00017: following statement failed with ORACLE error 721:<br>"BEGIN sys.dbms_plugts.checkCompType('COMPATSG','10.2.0.1.0'); END;" <br>IMP-00003: ORACLE error 721 encountered<br>ORA-00721 (See ORA-00721.ora-code.com): changes by release 10 .2.0.1.0 cannot be used by release 9.2.0.0.0<br>ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS _PLUGTS", line 2004<br>ORA-06512 (See ORA-06512.ora-code.com): at line 1<br>IMP-00000: Import terminated unsuccessfully <br><br>I am not using 9i DB, then why is the error ORA-00721 (See ORA-00721.ora-code.com): changes by release 10.2.0.1.0 cannot be used by release 9.2.0.0.0.<br><br>Please help... <br><br><br>--<br>Regards,<br><br>Deepak<br>Oracle DBA<br><br></blockquote> </div><br><br clear="all"><br>-- <br>Regards,<br><br>Deepak<br>Oracle DBA < /span></div></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br><br >Deepak<br>Oracle DBA
