May 8, 2002 #1 Sina Technical User Jan 2, 2001 309 CA Dear suppport users, How can I get a list of all the tables within a table space? Thank you all
May 8, 2002 #2 Turkbear Technical User Mar 22, 2002 8,631 US Hi Sina: Code: 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 ... Upvote 0 Downvote
Hi Sina: Code: 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 ...
May 8, 2002 1 #3 jimbopalmer Programmer Jul 20, 2001 2,904 US 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. Upvote 0 Downvote
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.