| Question about importing schemas [message #243034] |
Tue, 05 June 2007 14:50  |
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
|
Member |
|
|
I have performed a export specifying which schemas I want however my target db is a new instance. Do I created the schemas or will the import create them for me?
Do I simply create the schemas granting them connect and resource only and specify grant=y in my import syntax?
Someone please help. Thanks.
|
|
|
|
|
|
|
|
| Re: Question about importing schemas [message #243299 is a reply to message #243034] |
Wed, 06 June 2007 16:03  |
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
|
Member |
|
|
Thanks so much Michel and Dreamz. I have another question during my export it reported questionable statistics. I went ahead and precreated the schemas with the necessary quota and imported as follows:
imp file=crexp_06052007.dmp log=crexp_06052007.log statistics=none buffer=100000 fromuser=CRORA touser=CRORA
but I got the following errors:
Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing CRORA's objects into CRORA
IMP-00017: following statement failed with ORACLE error 604:
"CREATE SEQUENCE "EXPENSE_PURE_SEQ" MINVALUE 33791103 MAXVALUE 9999999999999"
"99999999999999 INCREMENT BY 1 START WITH 33812334 CACHE 20 NOORDER NOCYCLE"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
ORA-06512: at line 32
Can you please shed some light on this?! Thanks so much for your help!
|
|
|
|
| Re: Question about importing schemas [message #243301 is a reply to message #243299] |
Wed, 06 June 2007 16:14 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
ORA-20000: %s
Cause: The stored procedure "raise_application_error" was called which causes
this error to be generated.
Action: Correct the problem as described in the error message or contact the
application administrator or DBA for more information. |
|
|
|
| Re: Question about importing schemas [message #243335 is a reply to message #243299] |
Wed, 06 June 2007 23:49 |
 |
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
| Quote: | ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
|
You have a trigger named xdb_installation_trigger that prevent you from creating your sequence.
Disable it before the import, you reeanable it after, if you really need it.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
