OraFAQ Forum: Backup & Recovery » Check the DB Size exclude particular table "A"

Home » RDBMS Server » Backup & Recovery » Check the DB Size exclude particular table "A" (Oracle 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check the DB Size exclude particular table "A" [message #562711]

Fri, 03 August 2012 12:09

mjkreddy1927
Messages: 20
Registered: February 2007

Junior Member

Hi Friends,

I am trying to calculate the compressed size of backup of my database by excluding table space ( and all the tables in that table space).

I know how to calculate the size of particular user DB size.

select sum(bytes/1024/1024)"size" from dba_segments where
owner='ABC';

Can some one help me.

Regards
j

Report message to a moderator

[Message index]

		Check the DB Size exclude particular table "A" By: mjkreddy1927 on Fri, 03 August 2012 12:09
		Re: Check the DB Size exclude particular table "A" By: John Watson on Fri, 03 August 2012 12:15
		Re: Check the DB Size exclude particular table "A" By: BlackSwan on Fri, 03 August 2012 12:15
		Re: Check the DB Size exclude particular table "A" By: mjkreddy1927 on Fri, 03 August 2012 14:42
		Re: Check the DB Size exclude particular table "A" By: Michel Cadot on Fri, 03 August 2012 14:49
		Re: Check the DB Size exclude particular table "A" By: BlackSwan on Fri, 03 August 2012 14:54
		Re: Check the DB Size exclude particular table "A" By: Michel Cadot on Fri, 03 August 2012 15:00
		Re: Check the DB Size exclude particular table "A" By: alan.kendall@nfl.com on Fri, 03 August 2012 18:17

Previous Topic:	ORA-00310: archived log contains sequence 12; sequence 9 required :
Next Topic:	Flash Recovery ->SYSTEM.DBF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 14:48:23 CDT 2024