We are trying to transport a tablespace from 8i to 9i. According to metalink Oracle
changed the NCHAR character set to 2 values so we dont have a match.
we can do an export/import, but no transportable tablespaces. Any known work around?
Short of destroying all our 8i databases and recreating them to match the 9i
standards(since the 9i ones cant use what is in 8i).
Connected to: Oracle9i Enterprise Edition RelEase 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
IMP-00002: failed to open expdat.dmp for read
Import file: expdat.dmp > /mnt/myfile.dbf
Export file created by EXPORT:V08.01.07 via conventional path
About to import transportable tablespace(s) metadata...
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
IMP-00017: following statement failed with ORACLE error 19736:
"BEGIN sys.dbms_plugts.beginImport ('8.1.7.3.0',31,'31',NULL,'NULL',226234"
",1569301,1); END;"
IMP-00003: ORACLE error 19736 encountered
ORA-19736: can not plug a tablespace into a database using a different national
character set
ORA-06512: at "SYS.DBMS_PLUGTS", line 1797
ORA-06512: at "SYS.DBMS_PLUGTS", line 1636
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 29344:
"BEGIN sys.dbms_plugts.checkUser('myuser); END;"
IMP-00003: ORACLE error 29344 encountered
ORA-29344: Owner validation failed - failed to match owner 'WEB_OWNER_3'
ORA-06512: at "SYS.DBMS_PLUGTS", line 1597
ORA-06512: at line 1
IMP-00034: Warning: FromUser "myuser" not found in export file
Import terminated successfully with warnings.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
