pls have a look at this
here is a procedure to alert the dba when a tablespace datafile is nearing its maxsize
would this work
create or replace procedure alrt_size (a out number(5))
select sum(bytes) into a from dba_data_files;
dbms_output.put_line('the datafile is nearing its maxsize');
how is that going to alert the dba? - where is dbms_output going to write to
well please tell me what should be used overthere instead of
well whatever program calls your procedure need to have something returned to it - so what is going to call your procedure?
Will any data file ever equal 90 bytes?????
this space intentionally left blank
forget abt the size thats just an example
just tell me if the procedure & logic is right
is there any other way to do this alert
Maybe you should check DBA_FREE_SPACE instead and send an e-mail with UTL_SMTP when free space < 10% of DBA_DATA_FILES.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
there is nothing right about it.
You know there are many tools freely available which do this for you
Click Here to Expand Forum to Full Width