My Oracle Support Banner

How to map each object to each edition it belongs to? (Doc ID 2143691.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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

To view full details, 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 a vibrant support community of peers and Oracle experts.