Re: tablespace

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


[Quoted] Tablespaces don't belong to anyone. You can get a list of the tablespaces [Quoted] by looking at the sys.dba_Tablespaces view. The datafiles that comprise [Quoted] 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 CEST

Original text of this message