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@xxxxxxxxxxxx> 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@xxxxxxxxx] > *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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto: > > oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DBA Deepak > > Sent: Thursday, 3 November 2005 9:14 PM > > To: oracle-l@xxxxxxxxxxxxx > > 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