从数据库得到所有的表

[zxm954712]

谁知道用什么可以看到这个数据库中所有的表.

[black_snail]

user_tables:->The tables which user owns
sys_tables:->The Tables which user can access
dba_tables:->All the tables in Database

Above Tables are from DICT View

BTW , You can do:
select * from tab to found out all the table and views which the user can access

[guorui_wh]

select OBJECT_NAME from user_objects where upper(OBJECT_TYPE)=upper('TABLE') ;

[black_snail]

哈哈，条条大路通罗马！

select SEGMENT_NAME from user_segments where segment_type='TABLE'

You can also fetch from DBA_SEGMENTS .

[zousky]

你这样仅仅只能看到该用户的下的所有表，有没有办法看到所有用户下的所有表？