Issues with recyclebin in 10.2.0.3.0
- From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 08 Aug 2008 10:07:41 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
