Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 oracle, after it was installed 2 patches: and

share|improve this question

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 then make sure you are using the exp.exe binary that is

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 patch.


share|improve this answer

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

Your Answer


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.