User and Schema

How Many Schema Object Types Can You Have

Posted on
It seems that Oracle does not list all the schema object types exhaustively in the documentation: Schema Object Types So, if you’d like to know all schema object types in your database, you can perform a query on the dictionary view dba_objects like the following query in an Oracle database 12c (12.1): [oracle@primary01 ~]$ sqlplus […]