Re: tablespace

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: 1999/03/31
Message-ID: <7dtbm9$9pe$1@defiant.btitelecom.net>#1/1

Tablespaces don't belong to anyone. You can get a list of the tablespaces by looking at the sys.dba_Tablespaces view. The datafiles that comprise those views are in sys.dba_data_files.

To get the tables in a tablespace, look at sys.dba_tables.

K.S. wrote in message <37016B99.62A53812_at_aol.com>...
>hi
>hopefully someone can help me out.
>
>How do you show a list of tablespaces belonging to abc?
>and
>How do you show a count of tables on the tablespace with the largest
>data file.
>
>thanks in advance
>k.s.
Received on Wed Mar 31 1999 - 00:00:00 CST