Issues with recyclebin in 10.2.0.3.0

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:
> COdbcStatement::ExecDirect())
> 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 dba_recyclebin 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 -- http://www.freelists.org/webpage/oracle-l