Errors RME-20 ORA-1403 ORA-6512 (SDD_TAB_D) ORA-4088 CDR-2000 RME-11 RME-222 When Deleting A Table From The Design Editor (Doc ID 279288.1)
Last updated on OCTOBER 27, 2016
Oracle Repository - Version 6.5 to 9.0 [Release Designer 6i] Information in this document applies to any platform.
Design Editor (DE)
"Checked for relevance on 08-Apr-2011"
Trying to delete a specific table from the Design Editor fails with the following errors:
RME-00020: Internal API error - ORA-01403: no data found ORA-01403: no data found ORA-06512: at "<Repository_Owner>.SDD_TAB_D", line 969 ORA-04088: error during execution of trigger '<Repository_Owner>.SDD_TAB_D' CDR-02000: Cannot delete Table Definition <Application_Name>/<Table_Name> RME-00011: Operation 'del' on TABLE_DEFINITION has failed RME-00222: Failed to dispatch operation to Repository RME-00222: Failed to dispatch operation to Repository
The table appears in a special color in the navigator of the DE.
Trying to add a column to this table fails with the following errors:
RME-00020: Internal API error - ORA-20291: integrity constraint (SDD_COL_OWNER) violated - parent key not found ORA-06512: at "<Repository_Owner>.SDD_COL_BR", line 39 ORA-04088: error during execution of trigger <Repository_Owner>.SDD_COL_BR' RME-00011: Operation 'ins' on COLUMN has failed RME-00222: Failed to dispatch operation to Repository
NB: same errors can occur for other Designer objects.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms