imp / exp pb
mirmadSep 28 2006 — edited Sep 28 2006Hi 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