Re: Tablespaces comparison

From: <>
Date: Wed, 2 Apr 2008 13:40:27 -0400
Message-ID: <>

Hi Zakai,

What do you mean by tablespace comparison?

For starter :

Select * from dba_data_files where tablespace_name = 'XXXX';

will give you sizing information.

Select * from dba_segments where tablespace_name='XXXX';

will give you information about all segments in tablespace.

You may run these queries for each tablespace and compare output.

HTH Mayen

"Zakai Kinan" <>
Sent by:
Apr 02 2008 01:03 PM
Please respond to


Tablespaces comparison

I have two servers that have identical tablespaces. Is it possible to compare them?

TIA, \ZK  

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

-- Received on Wed Apr 02 2008 - 12:40:27 CDT

Original text of this message