Re: Tables within a Tablespace

Silvester Pereira <sp_at_labyrinth.net.au> schrieb:
>
> How do you get a listing of
> a. all tablespaces within a Db?

SELECT * FROM dba_tablespaces;

> b. all tables within a particular tablespace?

SELECT * FROM dba_tables WHERE tablespace_name = 'TABLESPACE-NAME'

HTH, Kathinka Received on Tue Nov 23 1999 - 03:22:11 CST