Database Software

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.

Error in Importing Complete Database

ShoaibApr 21 2015 — edited Apr 22 2015

Hi Friends,

My Database Version

--------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

PL/SQL Release 10.2.0.3.0 - Production

CORE 10.2.0.3.0 Production

TNS for 64-bit Windows: Version 10.2.0.3.0 - Production

NLSRTL Version 10.2.0.3.0 - Production

--------------------------------------------------------

I have a Exported Dmp file from our production database.

Now I am having other fresh Installation of Oracle 10g. (Both database have same versions.) in which I created a new User by Using Following statement

Create User newinv identified by newinv.

Then I logged in as DBA an granted resource and connect ,imp_full_database rights to newinv.

When I am running Import command for full database import as

imp newinv/newinv@test file = d:\backup.dmp log = d:\backup_imp.log full = y

then its giving me errors like

INVROLE missing, Tablespace picture missing.

My question is what Else I need to do before making a full database import.Please help me.

Thanks

Shoaib

This post has been answered by Hemant K Chitale on Apr 22 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2015

Added on Apr 21 2015

#database-key-features, #export-import-sql-loader-external-tables

10 comments

2,700 views