Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it OK to drop Invalid Objects that have a Referenced_Owner/Referenced_Name? (dba_dependencies)

4089142Mar 10 2020 — edited Mar 11 2020

I attempting to clean out my Oracle 18c databases of Invalid Objects. I was given the go ahead from the developers to remove a few invalid objects but after googling, I noticed that I would have to watch out of other dependent objects.

If I drop these invalid objects would it have any effect on the referenced objects. Would it turn those invalid as well, creating more invalid objects? I already attempted to recompile and got compilation errors. I sent them to the application owners (Developers) and they said I can remove the objects. Below I provided the Invalid objects and the referenced objects to them. How should I clean out the invalid objects?

INVALID OBJECTS  **[OWNER / OBJECT NAME / OBJECT TYPE]**

PLAP/TEMP_DIS_CONSTR/PROCEDURE

PLAP/TEMP_DRP_CONSTR_PK/PROCEDURE

PLAP/TEMP_UPDATE_MILESTONE_TABLE/PROCEDURE

INVALID OBJECTS -----> REFERENCED OBJECTS

PLAP/TEMP_DIS_CONSTR/PROCEDURE -------> SYS/ALL_CONS_COLUMNS/VIEW

PLAP/TEMP_DIS_CONSTR/PROCEDURE -------> PUBLIC/DBMS_OUTPUT/SYNONYM

PLAP/TEMP_DIS_CONSTR/PROCEDURE -------> SYS/STANDARD/PACKAGE

PLAP/TEMP_DRP_CONSTR_PK/PROCEDURE ------> SYS/STANDARD/PACKAGE

PLAP/TEMP_DRP_CONSTR_PK/PROCEDURE ------> PUBLIC/DBMS_OUTPUT/SYNONYM

PLAP/TEMP_DRP_CONSTR_PK/PROCEDURE ------> PLAP/AOP_CAPABILITY_MILESTONES/TABLE

PLAP/TEMP_UPDATE_MILESTONE_TABLE/PROCEDURE ------> SYS/STANDARD/PACKAGE

PLAP/TEMP_UPDATE_MILESTONE_TABLE/PROCEDURE ------> PLAP/AOP_MILESTONES_SEQ/SEQUENCE

Thanks

Comments

Hi Penny,

This is a known issue.  Please connect with me directly for the fix.

Thank you,

Sherry

Hasnur Ramadhan

Hi Sherry,

Error in .ore.odm.chk.dbver() : DB version 19.0 is not supported

---

How to connect with you directly to get the fix?

Currently I am doing a POC using ORE Oracle 19c for a prospective customer.

TIA.

Hasnur R.

Hasnur Ramadhan

Solved with Oracle R Distribution 3.6.1, and re-download OML for R library 1.5.1 (the latest one, dated August 24, 2020).

1 person found this helpful
Sherry Lamonica-Oracle

Thank you for the update, Hasnur. Oracle R Distribution 3.6.1 is now available.  Refer to this blog post for details and a pointer to installation instructions with Oracle Machine Learning for R 1.5.1, which contains the fix for the OREdm bug discussed in this thread.

Sherry

1 person found this helpful
1 - 4

Post Details

Added on Mar 10 2020
#oracle, #plsql, #procedure
4 comments
657 views