具体如下:
SYS@dbaplus --> select table_name from dba_tables where table_name like '%\_O%' escape '\' and rownum<13; TABLE_NAME ------------------------------ FIXED_OBJ$ IND_ONLINE$ MAP_OBJECT DIR$MIGRATE_OPERATIONS DIR$SERVICE_OPERATIONS DIR$ESCALATE_OPERATIONS DIR$QUIESCE_OPERATIONS DIR$RESONATE_OPERATIONS STMT_AUDIT_OPTION_MAP WRI$_OPTSTAT_TAB_HISTORY WRI$_OPTSTAT_IND_HISTORY TABLE_NAME ------------------------------ WRI$_OPTSTAT_HISTHEAD_HISTORY 12 rows selected. SYS@dbaplus --> SYS@dbaplus --> select table_name from dba_tables where table_name like '%_O%' and rownum<13; TABLE_NAME ------------------------------ ICOL$ CON$ UNDO$ PROXY_ROLE_DATA$ COL$ PROXY_DATA$ BOOTSTRAP$ CCOL$ OBJERROR$ UGROUP$ SUPEROBJ$ TABLE_NAME ------------------------------ LOB$ 12 rows selected. SYS@dbaplus -->
————————
Done