I'm trying to export a schema from my 10g RAC database, but i'm getting a whole lot of errors. Infact, the same script i used to export the same schema from a 9i database successfully is what i'm using, as shown below:
> exp system/xxxxxx@labtest1 file=/u02/epiphany_sys.dmp owner=epiphany_sys_meta_data log=/u02/epiphany_sys.log statistics=none buffer=80000 consistent=y
The errors i'm getting are:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYS.LT_EXPORT_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
. exporting foreign function library names for user EPIPHANY_SYS_META_DATA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EPIPHANY_SYS_META_DATA
About to export EPIPHANY_SYS_META_DATA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully
Does anyone have an idea of what's going on? Your help will be highly appreciated.
Click Here to Expand Forum to Full Width