happydba

HTML clipboard .style1 { color: #FF0000; } .style2 { color: #0000FF; font-weight: bold; }

exp system/system owner=onecard file=d:\backup\irp.data log=d:\backup\irp.log
即将导出指定的用户…
. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 ONECARD 的外部函数库名称
. 导出 PUBLIC 类型同义词
. 导出私有类型同义词
. 正在导出用户 ONECARD 的对象类型定义
EXP-00008: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
EXP-00024: 未安装导出视图，请通知您的 DBA
EXP-00000: 导出终止失败

Cause

EXP toolos shows version as 9.2.0.6.0

While checking table SYS.DBA_REGISTRY , component version shows up earlier version i.e. 9.2.0.1.0 in this case. However this issue can happen other releases where version DBA_REGISTRY does not match version of oracle software installed

E:\oratest\bin>sqlplus “/ as sysdba”
SQL*Plus: Release 9.2.0.6.0 – Production on Thu May 19 19:07:32 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 – Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 – Production
SQL> select comp_id,version from dba_registry;

COMP_ID VERSION

CATALOG   9.2.0.1.0
CATPROC   9.2.0.1.0
OWM           9.2.0.1.0
JAVAVM     9.2.0.1.0
XML             9.2.0.2.0
CATJAVA    9.2.0.1.0
ORDIM        9.2.0.1.0
SDO             9.2.0.1.0
CONTEXT  9.2.0.1.0
XDB            9.2.0.1.0
WK             9.2.0.1.0
ODM          9.2.0.1.0
APS            9.2.0.1.0
XOQ          9.2.0.1.0
AMD 9.2.0.1.0

Though 9.2.0.6.0 patchset was applied , however the dictionary was not upgraded.
During the dictionray upgrade the catpatch.sql calls catexp.sql which creates new views for EXPORT.

Solution

To implement the solution, please execute the following steps:

1. please check dba_registry for comp version. If it shows 9.2.0.1 (or does not match software version with / ) for CATALOG & CATPROC component then you had applied the patch however you had not perform the patch post installation task.

2. The steps includes to run catpatch.sql for the Database which is running form the patched Home
Please refer Readme of patch associated with patch

3. Check dba_registry CATALOG &CATPROC component upgrade to 9206

4.Then run export utility

——————————————————————————————-

sql> @rdbms/admin/catpatch.sql

(如果版本一致，执行catexp.sql即可，否则，执行catpatch.sql)

ref:  catexp.sql

Rem
Rem $Header: catexp.sql 24-apr-2006.16:46:37 kamble Exp $ expvew.sql
Rem
Rem Copyright (c) 1987, 2006, Oracle. All rights reserved.
Rem NAME
Rem    CATEXP81.SQL – CATalog EXPort/import sql script
Rem  FUNCTION
Rem    Creates internal views for Export/Import utility
Rem  NOTES
Rem    Must be run when connected to SYS or INTERNAL.

ref: catpatch.sql

Rem
Rem $Header: catpatch.sql 08-apr-2004.22:36:25 arithikr Exp $
Rem
Rem catpatch.sql
Rem
Rem Copyright (c) 2001, 2004, Oracle Corporation.  All rights reserved.
Rem
Rem    NAME
Rem      catpatch.sql – Script to apply CATalog PATCH set to a database
Rem
Rem    DESCRIPTION
Rem      This script encapsulates the “post install” steps necessary
Rem      to migrate the dictionary to the new patchset version.
Rem      It runs the new patchset versions of catalog.sql and catproc.sql
Rem      and calls the component patch scripts.