以system登陆
select owner,object_name,object_type from dba_objects where object_type='TABLE' and owner='USERNAME';username 是你要看的那个用户的名称
select owner,object_name,object_type from dba_objects where object_type='TABLE' and owner='USERNAME';username 是你要看的那个用户的名称
或
select * from user_tables
都可以
SELECT * FROM TAB