Re: ORA-01917: user or role 'XDB' does not exist ?

From: Hans Wijte <hans.wijte_at_nl.ibm.com>
Date: Thu, 24 Apr 2008 15:49:36 +0200
Message-ID: <OFAF248C08.DC973D88-ONC1257435.004BB663-C1257435.004BF814@nl.ibm.com>


apparently your newly created database did not include an install of XML db , while the export file contains this user and his objects.

See
http://www.stanford.edu/dept/itss/docs/oracle/10g/appdev.101/b10790/appaman.htm

for a discussion how to install this in your new database

Hans

VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> Sent by: oracle-l-bounce_at_freelists.org
23-04-2008 22:43
Please respond to
VIVEK_SHARMA_at_infosys.com

To
"oracle-l_at_freelists.org" <oracle-l_at_freelists.org> cc

Subject
ORA-01917: user or role 'XDB' does not exist ?

Folks  

When trying to import data using impdp into a NEWLY Created 10gR2 Database, following error is occurring:  

ORA-39083: Object type PROCACT_SYSTEM failed to create with error: ORA-01917: user or role 'XDB' does not exist  

Qs How is the ?XDB? user to be Created?  

Cheers & Thanks indeed  

Vivek    

  • CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

Tenzij hierboven anders aangegeven: / Unless stated otherwise above: IBM Nederland B.V.
Gevestigd te Amsterdam
Inschrijving Handelsregister Amsterdam Nr. 33054214

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 24 2008 - 08:49:36 CDT

Original text of this message