-
space occupied by a schema
Hi Gurus
We are running Oracle 9i on Linux 7.1 . We got 8 schemas in our database and our database size is growing in a massive way. We figured out a schema which is not in use now and we want to drop that after taking a backup. Before dropping that schema, i want to know how much space is occupied by that schema in our database. Can any one please tell me how to calculate the space occupied by a particular schema? All our tablespaces are shared across different users. So, i can't calculate based on the TS size.
Any help would be greatly appreciated .....
Thanks in advance
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|