User and Schema

How Many Schema Object Types Can You Have

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 / as sysdba
...
SQL> set pagesize 100;
SQL> select distinct object_type from dba_objects order by 1;

OBJECT_TYPE
-----------------------
CLUSTER
CONSUMER GROUP
CONTEXT
DESTINATION
DIMENSION
DIRECTORY
EDITION
EVALUATION CONTEXT
FUNCTION
INDEX
INDEX PARTITION
INDEXTYPE
JAVA CLASS
JAVA DATA
JAVA RESOURCE
JAVA SOURCE
JOB
JOB CLASS
LIBRARY
LOB
LOB PARTITION
MATERIALIZED VIEW
OPERATOR
PACKAGE
PACKAGE BODY
PROCEDURE
PROGRAM
QUEUE
RESOURCE PLAN
RULE
RULE SET
SCHEDULE
SCHEDULER GROUP
SEQUENCE
SYNONYM
TABLE
TABLE PARTITION
TABLE SUBPARTITION
TRIGGER
TYPE
TYPE BODY
UNDEFINED
UNIFIED AUDIT POLICY
VIEW
WINDOW
XML SCHEMA

46 rows selected.

Now we know there’re 46 object types in our database 12c. For more information about views related to schema objects, you can refer to Oracle documentation:
Schema Objects Data Dictionary Views

Another question for you, do you know what schema objects are stored in SYSTEM tablespace? You can find the answer in my another post:
What Schema Objects are Stored in SYSTEM Tablespace by Default

Leave a Reply

Your email address will not be published. Required fields are marked *