Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: error transporting a tablespace from 8i to 9i?

Re: error transporting a tablespace from 8i to 9i?

From: Ryan <rgaffuri_at_cox.net>
Date: Mon, 15 Sep 2003 13:54:27 -0800
Message-ID: <F001.005CFF73.20030915135427@fatcity.com>


new database. we are just taking certain tablespaces to it. we are not ready to upgrade our 8i to 9i databases yet. However, we need to set something up in 9i for a new client.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 15, 2003 4:44 PM

> upgrade in place is not an option, or am i missing something?
>
> joe
>
>
> rgaffuri_at_cox.net wrote:
>
> >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: Joe Testa
> INET: oracle-l_at_oracle-dba.com
>
> 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: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: rgaffuri_at_cox.net

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: ListGuru_at_fatcity.com (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).
Received on Mon Sep 15 2003 - 16:54:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US