Re: Issues with recyclebin in 10.2.0.3.0
Date: Fri, 8 Aug 2008 17:07:15 -0400
All the issues I have encountered (so far) with recycle bin can be found at this URL:
At the time we were on 10.2.0.2 but we upgraded to 10.2.0.3 2 weeks ago. I have experienced performance issues but nothing that caused errors. Chances are data was modified as your transaction was running. A good starting point to read would be metalink Note:197246.1
On Fri, Aug 8, 2008 at 2:07 PM, Maureen English <sxmte_at_email.alaska.edu> wrote:
> Has anyone had any issues with the recyclebin in 10.2.0.3.0?
> We were doing a software upgrade using a database on HP Tru64
> and a script connecting to the database using an ODBC connection.
> The script was simply dropping about 60 tables (errors okay when
> tables didn't exist), then creating the tables, indexes, sequences.
> The user ran the script once and everything was fine. When he
> ran it a second time, he got the following error:
>> 01641 [08/02/08 09:42:54] Statement 0068 DBERR: SaveErrorInfo(): [SQL
>> Error: -1,
>> SQL State: HY000, Native Error Code: 604] SQL Message:
>> [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00604: error
>> occurred at recursive SQL level 1
>> ORA-08177: can't serialize access for this transaction --- Error text:
>> SQLExecDirect() failed (File: OdbcStatement.cpp, Line: 1133, Method:
>> 01641 [08/02/08 09:42:54] vpsql 0448 FATAL: ERROR: Error executing
>> statement at line: 180 ... Aborting...
> Restarting the database made no difference. I looked around a bit and
> found he had about 168 items in the recycle bin, so I did a purge
> and everything magically worked.
> From what I've read about the recycle bin, objects should disappear from
> it if you need the space. He certainly didn't need the space, and he had
> been disconnected from the database after running the script the first time.
> Even when he ran it upon restart of the database, he got the error.
> Any ideas on what might have been happening? I cannot reproduce the error
> using sqlplus from the database server or SQL Worksheet from my PC.
> - Maureen