Database Administration (MOSC)

MOSC Banner

Restore GSMADMIN_INTERNAL schema

Oracle 12c 12.2.0.1

The GSMADMIN_INTERNAL user was erroneously deleted apparently some weeks ago. Datapump no longer works for export (ORA39006 and 390065) as well as ORA-00942 table or view does not exist. And ultimately ORA-39097 Data Pump job encountered unexpected error -942

So, I'm wondering is there any practical way to restore the GSMADMIN_INTERNAL user and its objects? I do not have RMAN backups going back that far. I do have datapump dumps from before the deletion, but I suspect impdp.exe will be just as broken as expdp.exe. Is there a way to manually create the user and its objects?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center