ORA-39123 ORA-29345/dbms_metadata_util.load_stylesheets

ORA-39123: Data Pump transportable tablespace job aborted

ORA-29345: cannot plug a tablespace into a database using an incompatible character set

SQL> select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from

(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,

(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,

(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

  2    3    4  

TAB1.AA||'_'||TAB2.BB||'.'||TAB3.CC

--------------------------------------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from

(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,

(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,

(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

  2    3    4  

TAB1.AA||'_'||TAB2.BB||'.'||TAB3.CC

--------------------------------------------------------------------------------

AMERICAN_AMERICA.US7ASCII

alter database character set internal_use AL32UTF8;

alter database character set internal_use AL32UTF8;SQL> 

alter database character set internal_use AL32UTF8

*

ERROR at line 1:

ORA-12719: operation requires database is in RESTRICTED mode

SQL> shutdown immediate;

startup mount

alter system enable restricted session;

alter database character set internal_use AL32UTF8;SQL> 

alter database character set internal_use AL32UTF8

*

ERROR at line 1:

ORA-12719: operation requires database is in RESTRICTED mode

SQL> shutdown immediate;

startup mount

alter system enable restricted session;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ORACLE instance started.

Total System Global Area  926941184 bytes

Fixed Size                  1222648 bytes

Variable Size             490735624 bytes

Database Buffers          427819008 bytes

Redo Buffers                7163904 bytes

Database mounted.

SQL> 

System altered.

SQL> SQL> alter database character set internal_use AL32UTF8;

alter database character set internal_use AL32UTF8

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-01109: database not open

SQL> alter database open;

alter database character set internal_use AL32UTF8;

Database altered.

SQL> shutdown immediate;

startup mount

Database altered.

SQL> alter system disable restricted session;

 alter database open;  

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ORACLE instance started.

Total System Global Area  926941184 bytes

Fixed Size                  1222648 bytes

Variable Size             499124232 bytes

Database Buffers          419430400 bytes

Redo Buffers                7163904 bytes

Database mounted.

SQL> 

System altered.

SQL> SQL> alt

Database altered.

SQL> SQL>    

SP2-0042: unknown command "alt" - rest of line ignored.

SQL> 

SQL> select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from

   (select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,

   (select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,

   (select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

 

  2    3    4  

TAB1.AA||'_'||TAB2.BB||'.'||TAB3.CC

--------------------------------------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

ora-39006 ora-06512报错

 execute sys.dbms_metadata_util.load_stylesheets;   

PL/SQL procedure successfully completed.

再导入即可。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-767404/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-767404/