Home » SQL & PL/SQL » SQL & PL/SQL » Storage space allocation for user (oracle 9i,windows )
icon5.gif  Storage space allocation for user [message #362878] Thu, 04 December 2008 06:38 Go to next message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
hi folks,

I am in creating web based application using front end as java/j2ee and back end as Oracle 9i..In the application, i need to allocate the some amount of storage space [typically 5 MB] to employee for storing his personal/official data[such as incoming mails,word doc,power point presentation,text file etc.,]. This storage space [ like our usual mail storage space ] will be using by the user from the application which is developed by using java ...Also , If the limit exceed/cross the 90% of the space for user it should send the warning mail to the respective employee....

Database is in remote server machine.

However i don`t know how to achieve this task .

Friends please help me as soon as possible.

Thanks in advance............. : Cool
Re: Storage space allocation for user [message #362907 is a reply to message #362878] Thu, 04 December 2008 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use a job and UTL_MAIL.

Regards
Michel
icon6.gif  Re: Storage space allocation for user [message #363374 is a reply to message #362907] Sat, 06 December 2008 07:33 Go to previous messageGo to next message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
hi Michel ,
thanks for your reply ...but i couldn`t understand
can you explain it some detail manner..
Re: Storage space allocation for user [message #363378 is a reply to message #363374] Sat, 06 December 2008 09:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ You built a query that select all user in overquota
2/ You create a procedure that loop on this select and send a mail to user using utl_mail
3/ You create a job that call this procedure using dbms_job

Regards
Michel
Re: Storage space allocation for user [message #364745 is a reply to message #363378] Tue, 09 December 2008 22:50 Go to previous messageGo to next message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
thanks michel
Re: Storage space allocation for user [message #365245 is a reply to message #364745] Thu, 11 December 2008 03:58 Go to previous message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
i ll workout and let you know if any further queries
Previous Topic: Execution of multiple statements under WHEN NOT MATCHED clause in MERGE
Next Topic: Sql Query
Goto Forum:
  


Current Time: Tue Feb 18 14:03:39 CST 2025