Home » RDBMS Server » Server Utilities » Question about importing schemas
Question about importing schemas [message #243034] Tue, 05 June 2007 14:50 Go to next message
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 #243036 is a reply to message #243034] Tue, 05 June 2007 14:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to precreate the schemas with the requested quota on tablespace (or unlimited tablespace privilege) then import with grants.

Regards
Michel
Re: Question about importing schemas [message #243038 is a reply to message #243036] Tue, 05 June 2007 15:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
if you are using oracle 10g then by using remap_schema clause during Import will create it for you.

[Updated on: Tue, 05 June 2007 15:13]

Report message to a moderator

Re: Question about importing schemas [message #243299 is a reply to message #243034] Wed, 06 June 2007 16:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64140
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
Previous Topic: Import data in oracle 9i
Next Topic: Insert data into multiple tables from a single datafile
Goto Forum:
  


Current Time: Fri Dec 09 09:25:26 CST 2016

Total time taken to generate the page: 0.11052 seconds