| How to exp user? [message #80301] |
Wed, 04 September 2002 22:51  |
Fico
Messages: 26
Registered: July 2002
|
Junior Member |
|
|
when I run exp , raise error messages as :
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
How to correct it ?
Thanks.
|
|
|
|
| Re: How to exp user? [message #80307 is a reply to message #80301] |
Thu, 05 September 2002 02:05  |
nik
Messages: 55
Registered: January 2002
|
Member |
|
|
try granting insert to user(loading user) on table to be loaded. That is if it of course exists first.
n
eg. GRANT INSERT,(SELECT,UPDATE,DELETE) on TABLE TO USER;
|
|
|
|
| Re: How to exp user? [message #80313 is a reply to message #80301] |
Fri, 06 September 2002 06:19 |
Fico
Messages: 26
Registered: July 2002
|
Junior Member |
|
|
But I can export the user correctly on another pc.
My Db server is 8.1.7,and I have a win2000 server with oracle9i,on win2000 server,I want to export the db,but error raised.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
