Skip to Main Content
Forums

Oracle Database Discussions

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.

import problem

474047Jun 20 2006 — edited Jun 20 2006
Dear all,
I have an import problem, I have a dump file of a schema of a remote database and want to import it into a user schema at my local database and when I issue the import command it gives me an error that this export made by another dba and the dba must import this file

The export command I used was:
----------------------------------------
Exp hrd/hrd@ora file=c:\hrd.dmp rows=y

And the import command was:
------------------------------------
imp hrd/hrd file=c:\hrd.dmp rows=y

the error was:
------------
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

Comments

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

Post Details

Locked on Jul 18 2006
Added on Jun 20 2006
#general-database-discussions
3 comments
201 views