ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-39123 ORA-29345/dbms_metadata_util.load_stylesheets

ORA-39123 ORA-29345/dbms_metadata_util.load_stylesheets

原创 Linux操作系统 作者:yyp2009 时间:2013-07-29 17:52:52 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Drop Database
下一篇: Database_Properties
请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1024173