OraFAQ Forum: Server Utilities » ORA-39083,ORA-29821,ORA-06598

Home » RDBMS Server » Server Utilities » ORA-39083,ORA-29821,ORA-06598 (Oracle, 18.0.0.0.0,Red Hat Enterprise Linux Server release 7.9 (Maipo))

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

ORA-39083,ORA-29821,ORA-06598 [message #686240]

Mon, 11 July 2022 04:45

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi Oracle gurus,

User wanted to perform a specific user's refresh from one DB to another DB running on the same server.
User wants to drop those specific users exists in the target DB before the import.

The import was completed with 25 errors.

The errors were.

ORA-39083: Object type OPERATOR:"C$DIRECT2019"."RXNMOLSIM" failed to create with error:
ORA-29821: specified primary operator does not exist

Failing sql is:
CREATE OPERATOR "C$DIRECT2019"."RXNMOLSIM" BINDING(NUMBER) RETURN NUMBER ANCILLARY TO "C$DIRECT2019"."RXNSIM" (BLOB, VARCHAR2, VARCHAR2), "C$DIRECT2019"."RXNSIM" (BLOB, CLOB, VARCHAR2), "C$DIRECT2019"."RXNSIM" (BLOB, BLOB, VARCHAR2) USING "MDLRXNSIM"."RXNMOLSIM"
ORA-39083: Object type OPERATOR:"C$DIRECT2019"."SIMILARITY" failed to create with error:
ORA-29821: specified primary operator does not exist

ORA-39083: Object type REF_CONSTRAINT:"MWIQF"."FK_DE_FOLDERS_E_FOLDERS01" failed to create with error:
ORA-02298: cannot validate (MWIQF.FK_DE_FOLDERS_E_FOLDERS01) - parent keys not found

ORA-39083: Object type INDEXTYPE:"C$DIRECT2019"."RXIXMDL" failed to create with error:
ORA-06598: insufficient INHERIT PRIVILEGES privilege

FYI .. I performed export of users before stopping the application. When I tried to drop the users in the target DB, I couldn't drop it.
Then I informed the developer to stop the application and then dropped the users.
But the export of users in the source was performed before stopping the application.

Environment is prod.

Kindly help me to solve the issue.

Regards,
Balaji

[Updated on: Mon, 11 July 2022 04:46]

Report message to a moderator