OraFAQ Forum: Server Utilities » impdp without CREATE USER metadata

Home » RDBMS Server » Server Utilities » impdp without CREATE USER metadata (Oracle Database 10g Express Edition Release 10.2.0.1.0, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

impdp without CREATE USER metadata [message #664099]

Tue, 04 July 2017 09:58

chris2018
Messages: 16
Registered: February 2017

Junior Member

All,

when trying to restore a backup, created by my predecessor:

expdp hr/hr DIRECTORY=dumpdir DUMPFILE=hr.dmp LOGFILE=exp_hr.log

I get the following errors on a new oracle installation:

ORA-39083: Objekttyp PROCACT_SCHEMA konnte nicht erstellt werden, Fehler:
ORA-31625: Schema HR ist erforderlich, um dieses Objekt zu importieren, auf das
Schema kann jedoch nicht zugegriffen werden
ORA-01435: Benutzer ist nicht vorhanden.

According to this thread, objects like

Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

are missing in my dump. Supposed, my server crashed, I can't recreate the export. So is there any way to "restore" the missing stuff?

Thank you in advance.

- Chris

Report message to a moderator

[Message index]

		impdp without CREATE USER metadata By: chris2018 on Tue, 04 July 2017 09:58
		Re: impdp without CREATE USER metadata By: John Watson on Tue, 04 July 2017 10:02
		Re: impdp without CREATE USER metadata By: chris2018 on Tue, 04 July 2017 10:05
		Re: impdp without CREATE USER metadata By: John Watson on Tue, 04 July 2017 10:07
		Re: impdp without CREATE USER metadata By: chris2018 on Tue, 04 July 2017 10:13
		Re: impdp without CREATE USER metadata By: John Watson on Tue, 04 July 2017 10:17
		Re: impdp without CREATE USER metadata By: chris2018 on Tue, 04 July 2017 10:20
		Re: impdp without CREATE USER metadata By: John Watson on Tue, 04 July 2017 10:23
		Re: impdp without CREATE USER metadata By: chris2018 on Tue, 04 July 2017 10:32
		Re: impdp without CREATE USER metadata By: Michel Cadot on Tue, 04 July 2017 12:15
		Re: impdp without CREATE USER metadata By: Michel Cadot on Tue, 04 July 2017 12:25

Previous Topic:	Schema Expired & Locked after import
Next Topic:	SQLloader does not load blob

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:00:16 CDT 2024