Skip to Main Content

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!

imp / exp pb

mirmadSep 28 2006 — edited Sep 28 2006
Hi guys.

I have a QA db runing on sun solaris 10 (sparc). Its runing on oracle 10g r2 and will like to duplicate it on a windows (DEV)machine havaing the same oracle version. The QA have one main user where all the tables are created under.
So I decided to export/import the user

so on the QA here is what i did.

exp siebel/siebel file='/u01/siebel.exp'
The export succeeded withwarning and when trying to import it on the DEV box, here is what I did

imp siebel/siebl file=c:\siebel.exp
then I had an error saying that only a DBA can imp an exp done by a DBA (???)
Then I used
imp siebel/siebl file=c:\siebel.exp fromuser=siebel touser,
it worked but am having tonnes of errors! e.g ORA-01917: user or role 'SSE_ROLE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INSERT ON "EIM_ORG_EXT_UK" TO "SSE_ROLE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SSE_ROLE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "EIM_ORG_EXT_UK" TO "SSE_ROLE""


How can I overcome all these errors? Show ai duplicate the db? How?
Can any one help?
Thanks
DID
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2006
Added on Sep 28 2006
3 comments
305 views