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))
ORA-39083,ORA-29821,ORA-06598 [message #686240] Mon, 11 July 2022 04:45 Go to next message
BalajiDBA
Messages: 132
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

Re: ORA-39083,ORA-29821,ORA-06598 [message #686241 is a reply to message #686240] Tue, 12 July 2022 00:50 Go to previous message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Don't know the solution for this issue?

[Updated on: Tue, 12 July 2022 07:39]

Report message to a moderator

Previous Topic: SQLLOADER
Next Topic: External Table INTEGER Conversion to NUMBER is wrong
Goto Forum:
  


Current Time: Thu Feb 02 11:01:21 CST 2023