EXP-00008: ORACLE error 904 encountered的解决方法

类别:数据库 点击:0 评论:0 推荐:

【错误情况】

[oracle@ccdevsvr admin]$ exp wmap/pass@jackeydb

Export: Release 8.1.7.4.0 - Production on Fri Oct 8 11:28:37 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > host    

(2)U(sers), or (3)T(ables): (2)U > u

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WMAP
. exporting object type definitions for user WMAP
About to export WMAP's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export WMAP's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "SPOLICY": invalid identifier
EXP-00000: Export terminated unsuccessfully
[oracle@ccdevsvr admin]$


【解决方法一】 

本文地址:http://com.8s8s.com/it/it20336.htm