Objetos do usuário logado (Oracle)

1
2
3
4
5
6
7
8

SELECT 
   TABLE_TYPE, 
   COUNT(*) 
FROM   
   USER_CATALOG 
GROUP BY 
   TABLE_TYPE
;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

SELECT
   OBJECT_NAME,
   SUBOBJECT_NAME,
   OBJECT_ID,
   DATA_OBJECT_ID,
   OBJECT_TYPE,
   CREATED,
   LAST_DDL_TIME,
   TIMESTAMP,
   STATUS,
   TEMPORARY,
   GENERATED,
   SECONDARY,
   NAMESPACE,
   EDITION_NAME
FROM
   USER_OBJECTS
;