Re: Transaport TS error

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_at_ixora.com.au> 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_at_gmail.com]
> *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_at_ixora.com.au> 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_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] On Behalf Of DBA Deepak
> > Sent: Thursday, 3 November 2005 9:14 PM
> > To: oracle-l_at_freelists.org
> > 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: changes by release 10.2.0.1.0 cannot be used by release
> > 9.2.0.0.0
> > ORA-06512: at "SYS.DBMS_PLUGTS", line 2004
> > ORA-06512: at line 1
> > IMP-00000: Import terminated unsuccessfully
> >
> > I am not using 9i DB, then why is the error ORA-00721: 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

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