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?