Re: Tablespaces comparison

Is there a better way to do this on two different
servers that are supposed to be identical?

Thx

\ZK


--- Mayen.Shah@xxxxxxxxxx wrote:

> 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@xxxxxxxxx> 
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> Apr 02 2008 01:03 PM
> Please respond to
> titanyen2000@xxxxxxxxx
> 
> 
> To
> oracle-l@xxxxxxxxxxxxx
> 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
> 
> 
> 
> 
> 



      
____________________________________________________________________________________
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


Other related posts: