RE: XMLTYPE

From: <oracle-l-bounce_at_freelists.org>
Date: Wed, 12 Apr 2006 07:16:20 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5874@MSXVS04.trivadis.com>

>If you encounter the error as described by M.Godlewski
>it is also could practice to disable the recyclebin
>and/or, if you don't use the recyclebin feature, to
>disable it completely via an alter system statement.

If you are on 10gR2 and you try to disable the recyclebin at session level be aware of bug# 4695236. In fact ALTER SESSION SET RECYCLEBIN behaves like ALTER SYSTEM SET RECYCLEBIN, only exception is that the change is not visible in V$PARAMETER!

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 12 2006 - 00:16:20 CDT