RE: exp and imp don't work

Maybe you don't have the right privileges. To run export and import one must
have the CREATE SESSION privilege on an Oracle DB. If you are exporting
tables owned by another user you should have the EXP_FULL_DATABASE role
enabled and granted to you. For import you should have the IMP_FULL_DATABASE
role enabled and granted to you.

-----Original Message-----
From: Karen van der Ploeg [mailto:[email protected]]
Sent: Wednesday, February 26, 2003 11:19 AM
To: Oracle
Subject: [oracle] exp and imp don't work


Hi 

I am running oracle 8.1.7.2.0 on several sun solaris 8 servers and on one 
of them I cannot use exp or imp. Typing exp results in the following 
error: 
Export: Release 8.1.7.2.0 - Production on Wed Feb 26 16:49:43 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


EXP-00056:
EXP-00000: Export terminated unsuccessfully

I tried searching google, my own oracle documentation of course and asked 
an experienced friend dba but no solution came up. 

The main difference between the server on which it doesn't work and the 
ones where it does work is that the one that gives me the error is part of 
a cluster (sun cluster 2.0) and the other ones are standalone. Further 
there are no obvious differences. Anybody have any idea? 

Karen. 
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].