SHOW TABLES;

SELECT table_name FROM user_tables;

<관리자모드>

SELECT owner, table_name FROM all_tables WHERE owner = '사용자계정명';

<내 테이블에 어떤 계정이 있을지 모를때>

SELECT owner, table_name FROM all_tables WHERE table_name LIKE '%MEMBER%' OR table_name LIKE '%PRODUCT%';