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

"Charles Hooper" <hooperc2000_at_yahoo.com> a écrit dans le message de news: 1164047313.958978.275050_at_m73g2000cwd.googlegroups.com...
| 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.
|

Take care that due to a bug "alter session" acts almost like "alter system", that is when you issue "alter session set recyclebin=off" then all sessions see their recyclebin turns off even if if they see "on" querying v$parameter. I posted a test case referenced as bug 5609913 on Metalink.

Regards
Michel Cadot Received on Mon Nov 20 2006 - 12:50:50 CST