How to map each object to each edition it belongs to?

(Doc ID 2143691.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

 This note explains how we can map objects to the edition it belongs to using an example.


For example :


select owner#,obj#,name,type#,status from sys.obj$ where name = 'TEST_PKG' or name = 'OE_AK_CUST_PO_NUMBER_V';

OWNER# OBJ# NAME TYPE# STATUS
---------- ---------- ------------------------------ ---------- ----------
100 338318 OE_AK_CUST_PO_NUMBER_V 4 1
468 672444 OE_AK_CUST_PO_NUMBER_V 88 1 <<< how do I know obj# 672444 is included in which edition? which table$ should I join with?

653 875736 OE_AK_CUST_PO_NUMBER_V 88 1
988 1261470 OE_AK_CUST_PO_NUMBER_V 88 1
1209 1481718 OE_AK_CUST_PO_NUMBER_V 88 1
1383 1716362 OE_AK_CUST_PO_NUMBER_V 88 1
1383 1790855 TEST_PKG 9 1
1383 1790856 TEST_PKG 11 1

 

Solution

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