Re: Simple question about tablespaces.

Select table_name from dba_tables where tablespace_name = 'yourtspace';

also remember that Indexes are also stored in tablespaces:

Select index_name from dba_indexes where tablespace_name = 'yourtspace';

Regards,

David.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!