Tuesday, 10 January 2012

User export failed with error EXP-00008/ORA-00904: "MAXSIZE"/"OLEVEL": invalid identifier

User export failed with error EXP-00008/ORA-00904: "MAXSIZE"/"OLEVEL": invalid identifier

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_DIST_COMP_RECORD_R

EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table DMI_DIST_COMP_RECORD_S

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_DUMP_OBJECT_RECORD_S

EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table DMI_EXPR_CODE_S

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_INDEX_R

Cause:
Depends upon the version mismatch.
like if you trying to take a export from 11.x.x.x.x home to 10.x.x.x.x dump file, you will get this error.

Solution:
If you want to take exp from db version 10.x.x.x.x serious, try it from some other database with same version.


example:
cd /opt/oracle/product/11.1.0.7/db_1/bin
./exp system/password@10gdb(tnshostname) full=y file=/oradata/export/prod007.dmp log==/oradata/export/prod007.log

you will get below error...
User export failed with error EXP-00008/ORA-00904: "MAXSIZE": invalid identifier




see Metalink ID :-741984.1

No comments:

Post a Comment