Re: get full size of oracle tablespace
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Sat, 16 Jan 2010 04:32:38 -0800 (PST)
Message-ID: <e2ef04f9-3d8f-426d-8594-39cbe39579a6_at_34g2000yqp.googlegroups.com>
Date: Sat, 16 Jan 2010 04:32:38 -0800 (PST)
Message-ID: <e2ef04f9-3d8f-426d-8594-39cbe39579a6_at_34g2000yqp.googlegroups.com>
On Jan 16, 6:08 am, Anabolik <bum..._at_gmail.com> wrote:
> Is there the way to get the full size of tablespace except from table
> dba_data_files?
I think using dba_data_files is the easiest way to get the full size of a tablespace but you can generate the same information using v$ views: v$datafile and v$tablespace.
This question would have been better posted to the oracle.server or .misc newsgroups.
HTH -- Mark D Powell -- Received on Sat Jan 16 2010 - 13:32:38 CET