Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

imp ?

829496Feb 2 2011 — edited Feb 3 2011
I am trying to import a dmp file in full. I believe I need sysdba rights. So I granted sysdba rights to the user i am going to import it to.
grant sysdba to Nate1;

C:\edatdmpfile>imp Nate1/pass file=ehmlink_exp.dmp log=imp.log full=yes

Import: Release 10.2.0.1.0 - Production on Wed Feb 2 10:29:51 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio
n

Export file created by EXPORT:V10.02.01 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully


I checked in toad and it say's the user Nate1 has sysdba rights.
Why is this not working???

Thanks for any help

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 3 2011
Added on Feb 2 2011
4 comments
259 views