FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / EXP- IMP- Error Codes

EXP-00008: ORACLE error 942 encountered

Admin — Tue, 28 Jul 2009 16:29:55 GMT

When exporting, we're getting the following error:

EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

Regarding this error you want to first make sure that the user you are using has EXP_FULL_DATABASE granted to it.

Then you you must run the following when you create the db and make sure there are no errors:
%ORACLE_HOME%/rdbms/admin/catalog.sql
%ORACLE_HOME%/rdbms/admin/catproc.sql

Hope this helps.

Thanks,

IMP-00003:ORACLE error 1435 encountered.

Admin — Tue, 28 Jul 2009 16:22:03 GMT

When importing a dump, we get the following error into another machine.

IMP-00003:ORACLE error 1435 encountered.
ORA-01435 user doesn't exist
IMPORT terminated unsuccessfully.

This is somewhat easy solution. Check to see if your target database has the user you are trying to import. If not, you may want to create the user first and then import. Or you can simply do FROMUSER TOUSER to another user.

Another solution would be to take full export with rows=n and try to get all the schemas imported with full=y and rows=nn this way you got the schemas going. Then do an import with rows=y .

Hope this helps,

Thanks,

EXP-00056: ORACLE error 19206 encountered during an export

Admin — Tue, 28 Jul 2009 15:47:31 GMT

Hi,

I'm getting the following error code when exporting :

EXP-00056: ORACLE error 19206 encountered during an export

I was getting this while exporting entire schema:

EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 353
ORA-06512: at "SYS.DBMS_METADATA", line 418
ORA-06512: at "SYS.DBMS_METADATA", line 457
ORA-06512: at "SYS.DBMS_METADATA", line 1181
ORA-06512: at "SYS.DBMS_METADATA", line 1162
ORA-06512: at line 1
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 353
ORA-06512: at "SYS.DBMS_METADATA", line 418
ORA-06512: at "SYS.DBMS_METADATA", line 457
ORA-06512: at "SYS.DBMS_METADATA", line 1181
ORA-06512: at "SYS.DBMS_METADATA", line 1162
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
(END)

I couldn't figure it out at first and tried and verified all my settings. Then I came across a find where there was a mention of xmldb modification. Recently there was and it might have been corrrupted. I connected as sysdba and ran the following and it fixed it:

$ORACLE_HOME/rdbms/admin/catmeta.sql