How can I get a list of all the tables within a table space? 1

[Sina]

Dear suppport users,

How can I get a list of all the tables within a table space?

Thank you all

 

[Turkbear]

Hi Sina:

Select table_name from all_tables where
tablespace_name = "whatever";

will give you all the tables you have access to; If you have dba privs, then use dba_tables instead ...

 

[jimbopalmer]

Select table_name from user_tables;

That will show THAT user's tables, usually all in one tablespace. I tried to remain child-like, all I acheived was childish.