Find Object Owner For A Table
718168Nov 3 2010 — edited Nov 3 2010All,
Is there a way to find out the oracle system generated name of any object in the database.
I am aware we can find the object names from dba_objects but i want to find out the system generated one by oracle.
e.g
SQL> select object_name,object_type from dba_objects where owner='SCOTT';
OBJECT_NAME OBJECT_TYPE
---------------------------------------- -------------------
DEPT TABLE
EMP TABLE
BONUS TABLE
In this eg i can see the object name but i need the name that oracle generates.
Is there a way to find this out?