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.
>
> Thank you,
>
> doug

One possibility - login trigger that executes the following for specific users:
ALTER SESSION SET RECYCLEBIN=OFF Another possibility is to completely disable the recycle bin using a similar ALTER SYSTEM command.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Nov 20 2006 - 12:28:34 CST