Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablespace alert

sam995972May 6 2013 — edited May 7 2013

hi all,

oracle 9.2.0.5
linux

Actually my database is olap's one, am having 100+ tablespaces each tbs is having more than 50GB + of space occupied, am planning to get the alert when tablespace which is having less than 1GB free space. Can anyone please tell me how to write a sql script and shell.

thanks,
Sam.

This post has been answered by DB_Janitor on May 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2013

Added on May 6 2013

#general-database-discussions

10 comments

1,391 views