Chinaunix首页 | 论坛 | 博客
  • 博客访问: 10170866
  • 博文数量: 1669
  • 博客积分: 16831
  • 博客等级: 上将
  • 技术积分: 12594
  • 用 户 组: 普通用户
  • 注册时间: 2011-02-25 07:23
个人简介

柔中带刚,刚中带柔,淫荡中富含柔和,刚猛中荡漾风骚,无坚不摧,无孔不入!

文章分类

全部博文(1669)

文章存档

2023年(4)

2022年(1)

2021年(10)

2020年(24)

2019年(4)

2018年(19)

2017年(66)

2016年(60)

2015年(49)

2014年(201)

2013年(221)

2012年(638)

2011年(372)

分类: Oracle

2011-12-26 10:16:31

ORA-39213: Metadata processing is not available 解决方法
分类: Oracle 故障解决案例 545人阅读 评论(0) 举报

 

Oracle 11.2.0.3 impdp 报错:

 

gg2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;

 

Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:35:19 2011

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

ORA-39006: internal error

ORA-39213: Metadata processing is notavailable

 

查看ORA-39213 具体内容:

gg2:/u01/backup> oerr ora 39213

39213, 00000, "Metadata processing isnot available"

// *Cause: The Data Pump could not use the Metadata API.  Typically,

//         this is caused by the XSL stylesheets not being set up properly.

// *Action: Connect AS SYSDBA and executedbms_metadata_util.load_stylesheets

//         to reload the stylesheets.

gg2:/u01/backup>

 

运行脚本:

SQL> conn / as sysdba;

Connected.

SQL> executesys.dbms_metadata_util.load_stylesheets;

 

PL/SQL procedure successfully completed.

 

再次impdp 成功:

gg2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;

 

Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:39:40 2011

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

Master table "DAVE"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded

Starting"DAVE"."SYS_IMPORT_TABLE_01":  dave/******** directory=backupdumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace

Processing object typeTABLE_EXPORT/TABLE/TABLE

Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA

. . imported"DAVE"."PDBA"                               49.14 MB 2713235rows

Job"DAVE"."SYS_IMPORT_TABLE_01" successfully completed at 12:40:16

 

 

 

阅读(1496) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~