oracle 查看用户的所有对象

SQL> col object_name for a30
SQL> /

OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
A1 TABLE
A2 TABLE
A3 TABLE
UP_TEST TABLE
OB_BAK TABLE
OB_BAK2 TABLE
TEMP_UP TABLE
OB_INDEX INDEX
AFTER_COM TABLE
UP_TEMP TABLE
OB_COM TABLE

OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
OVER_COM TABLE
OB_VIEW VIEW

已选择13行。

SQL> l
1* select object_name,object_type from dba_objects where owner=upper('awen')