Re: Tablespaces comparison

From: Zakai Kinan <titanyen2000_at_yahoo.com>
Date: Wed, 2 Apr 2008 10:48:47 -0700 (PDT)
Message-ID: <476887.6191.qm@web32607.mail.mud.yahoo.com>

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

Thx

\ZK

• Mayen.Shah_at_lazard.com 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_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
>
>
>
>
>

---

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

Received on Wed Apr 02 2008 - 12:48:47 CDT