Skip to Main Content

Oracle Database Components dependencies - data dictionary view

Emad Al-MousaAug 21 2015 — edited Aug 22 2015

any DBA can query the list of database components installed on his database using DBA_REGISTRY data dictionary view.  However, its very difficult to know what are the dependencies (relationship) between them, how i can safely un-install the components in the right order to avoid any problems.

it will be very nice if we have a data dictionary view that list the relation ship (dependencies ) between database components with full information , so the DBA can get this kind of information quickly.

for example, i found out that JAVAVM has dependencies with spatial,multimedia and OLAP components.

Post Details
Added on Aug 21 2015