Re: 10g recyclebin with 9i SQL*Plus clients

old dirtbeard wrote:
>
> Thank you for your response. This server is being used by university data
> management students and they are running SQL DDL statements over and over as
> they debug their programs (they may need to recreate and drop the same
> tables dozens of times and it just adds a great deal of clutter on their
> screens and a great deal of wasted storage on the server).
>
> I really cannot upgrade all of the clients as they are logging in from their
> home machines, there are labs on campus that will not get new images until
> January, etc. I would like to be able to work-around this to get through the
> end of the semester.

Since the students don't expect to find things in the recycle bin ( apparently based on what you said ), you could script up something to purge all the recycle bin contents on whatever schedule you see as appropriate ( daily, hourly ? ).

If you go against the dba recycle bin you can whack all the stuff at once in the recycle bin. Received on Mon Nov 20 2006 - 12:35:12 CST