The error "EXP-00056: ORACLE error 6502 encountered" looks like this
in export log files:
EXP-00056: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3296
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4148
ORA-06512: at "SYS.DBMS_METADATA", line 458
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
Sometime this error will be due to invalid packages, and the first
step is to check:
select comp_id,
version, status from dba_registry;
The exp-00056 with the 6502 error happens under several
circumstances:
1 - Bugs - See Oracle patch Patch 3361288, and
MOSC note 334473.1. There may be missing XDB views;
select * from sys.metastylesheet;
If the stylesheet column shows "not
initialized" , there is a problem, and run this to fix:
SQL> @$ORACLE_HOME/rdbms/admin/initmeta.sql
2 - Conflicting releases - The target and local
databases must be on exactly the same release of Oracle. The
EXP-00056 with 6502 has happened when the target database is Oracle9i
Enterprise Edition Release 9.2.0.4.0. and local database is Oracle9i
Enterprise Edition Release 9.2.0.1.0.
3 - Using incorrect data type variables - Dave
Herring noted the EXP-00056 with 6502: " started getting the same error
after upgrading from 9.2.0.4 to 9.2.0.6, when setting a VARCHAR2(4000)
variable to output from DBMS_METADATA.GET_DDL ... I changed the
statement to do a SUBSTR(...1,4000) and that resolved it.
|
|
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|