Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I rut the following:

set ORACLE_SID=orcl
exp.exe 'SYS/system as sysdba' full=y log=exp.log  file=mydump.dmp

in the end i see the following:

EXP-00056: ORACLE error 942 encountered

ORA-00942: table or view does not exist

EXP-00000: Export terminated unsuccessfully

what should i do to resolve it?

I had 9.2.0.1.0 oracle, after it was installed 2 patches: 9.2.0.7.0 and 9.2.0.8.0

share|improve this question
add comment

2 Answers

It looks like your export statement is valid but I have seen this when trying to mix/match export/import versions and databases.

Are you using the export binaries that go with the version of the database you are using? If you just type 'exp' it will tell you the version.

The version of your exp.exe should be the same as the database version you are trying to export. The exp.exe relies on structures in the database and these can change from release to release. So if your database is 9.2.0.8.0 then make sure you are using the exp.exe binary that is 9.2.0.8.0.

You may want to read Using Different Releases and Versions of Export for more detail.

If you think your database and binarie may match and you still have problems then you may have had an issue when running catpatch scripts after your 9.2.0.8.0 patch.

-Dave

share|improve this answer
add comment

There are a number of views that must exist in order for import/export to run.

Run the following as the SYS user: /rdbms/admin/catexp.sql to create them.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.