User Space-used script

[KenEwald]

I want to figure out how much space I'll need for an export of a specific schema.

I need a script to query how much space a user's tables (only) are using.

If you've got one in your cache of scripts, please share.

Thanks you.

[amar]

won't the

select sum(bytes) from user_segments where segment_type='TABLE';

query give you a ballpark figure when issued from the user whose tables you want to export ?

-amar

[KenEwald]

I ran the query after exporting one schema. The .dmp file is 968,275,968. The query shows 787,906,560 bytes.

This gives me a ball-park estimate (well, within 25%). Thank you.

I wonder if there's something that'll get a little closer? I'm also curious about the variance. Any Ideas?

[amar]

Refer to metalink doc 106465.1 to find out the exact dump file size. It's a pain - but you will get the exact figure.

As for the variance, maybe refer to doc 61949.1?

-amar

[KenEwald]

Will do Amar. Thank you for your time and the references.

[clio_usa]

Ken,

Here is a way to get this info. It will show you the HWM for each table in selected schema and with little twisting could get the SUM as well.

Here is the link:
http://www.dbaclick.com/cgi-bin/ib3/...=ST;f=15;t=190


Check the latest Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

--clio_usa

[KenEwald]

Thanks Clio