OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » size of schema

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

size of schema [message #154269]

Fri, 06 January 2006 09:09

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi,
I think this is the correct forum.

Is it possible to find out how big a users schema is.
I have a large DB 275GB of which I need to export individual users (schemas)

regards

Alan.

Report message to a moderator

Re: size of schema [message #154270 is a reply to message #154269]

Fri, 06 January 2006 09:23

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Try this

select sum(bytes)/(1024*1024*1024) "GB" from dba_segments
where owner='<schema_name / username>';

-Sai Jeedigunta

Report message to a moderator

Re: size of schema [message #154276 is a reply to message #154269]

Fri, 06 January 2006 10:00

DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina

Junior Member

Hi Sai, Hi Alan Smile

That's correct, but probabily this minor modification can be usefull for Alan:

select OWNER, sum(bytes)/(1024*1024*1024) "GB"
from dba_segments
GROUP BY owner;

Regards.
Daniel

[Updated on: Fri, 06 January 2006 10:01]

Report message to a moderator

Re: size of schema [message #154582 is a reply to message #154269]

Mon, 09 January 2006 09:39

alanm
Messages: 284
Registered: March 2005

Senior Member

thanks for the help.

Cool

Report message to a moderator

Previous Topic:	Temporary Tablespace not shrinking automatically after restarting the DB.
Next Topic:	ora-01927 cannot revoke privilege you did not grant

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:31:58 CDT 2024