Re: Tablespaces comparison

From: <Mayen.Shah_at_lazard.com>
Date: Wed, 2 Apr 2008 13:40:27 -0400
Message-ID: <OF8FAE02D5.C425812F-ON8525741F.0060BB2A-8525741F.00611694@lazard.com>

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" <titanyen2000_at_yahoo.com>
Sent by: oracle-l-bounce_at_freelists.org
Apr 02 2008 01:03 PM
Please respond to
titanyen2000_at_yahoo.com

To
oracle-l_at_freelists.org
cc

Subject
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.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 02 2008 - 12:40:27 CDT