| Import error [message #166689] |
Fri, 07 April 2006 10:15  |
vijay_alans
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
Hello Gurus,
I'm not a DBA but trying to do some DBA work.
I did an export of a schema which created a 3GB file and tried to import it in different database.
Following are the commands I issued for Export/Import:
exp siebel/siebel file=siebel.dmp log=siebel.log compress=y
imp userid=siebel/siebel@siebdb_vj file=siebel.dmp log=siebelimp.log full=y
Following is the error i'm ending up:
IMP-00017: following statement failed with ORACLE error 604:
" ALTER TABLE "CX_CODE_LOOKUP" MODIFY ("CREATED" DEFAULT sysdate )"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 604:
" ALTER TABLE "CX_MSLL_INT_LOG" MODIFY ("CREATED" DEFAULT sysdate )"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I tried my best in forums to find a resolution but can't.
Any thoughtful guidance is really appreciated.
Thanks,
Vijay
|
|
|
|
| Re: Import error [message #166727 is a reply to message #166689] |
Fri, 07 April 2006 19:23  |
vijay_alans
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
Hello Gurus,
Managed to solve the issue.
The IMP untility tries to create the tables in same tablespace from where EXP utility generated the dmp file. So, after creating the same tablespaces the utility ran successfully.
Cheers,
Vijay
|
|
|
|
| Re: Import error [message #168996 is a reply to message #166689] |
Mon, 24 April 2006 09:36 |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
so i guess
an import dosent create tablespace and users on the destination database , we have to create them before starting the imp
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
