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 laterGen 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! |