Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1049564
  • 博文数量: 276
  • 博客积分: 10077
  • 博客等级: 上将
  • 技术积分: 2513
  • 用 户 组: 普通用户
  • 注册时间: 2007-08-24 20:31
文章分类

全部博文(276)

文章存档

2020年(1)

2015年(5)

2012年(2)

2011年(6)

2010年(7)

2009年(224)

2008年(31)

我的朋友

分类: Oracle

2009-03-11 14:53:35

+++++++++++++++++++++++++++++++++++
C:\>%oracle_home%\bin\exp userid=crpdb/crpdb owner=crpdb indexes=y buffer=81920
log=f:\log.log file=f:\crpdb.dmp
Export: Release 9.2.0.5.0 - Production on Wed Mar 11 14:44:45 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining option
s
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CRPDB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CRPDB
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
+++++++++++++++++++++++++++++++++++
solution
错误原因是没有安装导出视图
先用sys登陆为sysdba,运行
$ORACLE_HOME/rdbms/admin/catexp.sql
$ORACLE_HOME/rdbms/admin/utlrp.sql
阅读(1104) | 评论(0) | 转发(0) |
0

上一篇:Zmanda backup mysql

下一篇:RAC Delete Node

给主人留下些什么吧!~~