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.

IMP - EXP issue

rahulrasApr 8 2008 — edited Apr 10 2008
Hi all,

I am on 9.2 (Solaris).
I have a export dump file taken from another database, which needs to be imported in my schema.
Also, I am not sure if it is a schema export or whole database export. Most likely it is a schema export ( as I asked for that ). Let us assume, it is schema export dump.

I am trying to import it using SHOW=Y option i.e. only list the contents, do not do the actual load. It throws error,

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

I can see that, a DBA (or user with DBA privilege) has exported this file and the user I am trying to import is not a DBA.

Does that mean, if a DBA exports a file, weather is a full schema export or database export or export of few selected tables, that can be imported only by a DBA (or user with DBA privilege) ? or it depends on the contents of export dump (i.e. if it a full schema export or just few tables exported) ??

Please share your experiences.

Thanks

Comments

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

Post Details

Locked on May 8 2008
Added on Apr 8 2008
#general-database-discussions
10 comments
820 views