如何查询一个用户下的所有表

方法一：以A用户登录数据库，执行select table_name from user_tables;

方法二：以system用户登录数据，执行select table_name from dba_tables where owner='用户名';

注意用户名大小写（因为加了“”要注意大小写）比如select table_name from dba_tables where owner='SCOTT;，否则如果用select table_name from dba_tables where owner='scottT会出现未选定行提示。

转自:http://zhidao.baidu.com/question/256127142.html

补充一下:

USER_TABLES describes the relational tables owned by the current user. Its columns (except for OWNER) are the same as those in ALL_TABLES. To gather statistics for this view, use the ANALYZE SQL statement.

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

参考：http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_2117.htm#i1592091       Oracle® Database Reference 11g Release 2 (11.2)