Error received when using the Export Wizard and logged in as the owner of tables that will be exported:
"ORA-00942: table or view does not exist"
Steps to replicate:
1) Connect to Toad
2) Go to DBA | Export Utility Wizard | Export Table | Designate Export file
3) Export fails with this error: "ORA-00942: table or view does not exist"
Verify that the following criteria is being meet when exporting table data:
1) Verify that you are using the same Oracle client and database versions.
2) If multiple clients are installed on the computer, verify that the correct client path is specified in the View | Options | Executables window for EXP.EXE. If the incorrect client is specified, click Auto-find to designate the path of the "EXP.EXE" file. Refer to the attached screenshot.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center