That will show you what tables you own not what tables are in a tablespace.
Log in as dba and do
select table_name, owner from dba_tables where tablespace ='MYTABLESPACE';
and that will tell you the tables and who owns them in a particular
tablespace.
Jim
"eugene kim" <eugene1977_at_hotmail.com> wrote in message
news:al98o5$qcf$1_at_newsreader.mailgate.org...
> hi i'm currently using this command to see what tables are in my
> tablespace..
> is there any shorter, informative way to do this?
> like describe tablespace?
>
> select table_name from user_tables;
>
> thank you
Received on Fri Sep 06 2002 - 00:10:02 CDT
