I have installed Oracle 9i server on Windows 2000 and clients on other machines. The database name is admin. I have created tables in my own login ora102 on the client machine. Now I want to export the tables which I have created in my own login. I used the following command on theclient machine to export tables:
exp ora102/ora102@admin file=c:demo.dmp tables=(emp,dept)
But it’s giving me the following error:
Exp 00056: oracle error 942 occured
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
I also executed catexp.sql, catalog.sql, catproc.sql. but I am still having this problem.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!