Recently my nightly OLAP build kept
failing with the error message
"ORA-38301: can not perform DDL/DML
over objects in Recycle Bin".
I encountered this problem
when I dropped a table with the
following command: drop table
buying_group;
The drop
happened fine, but then when I try
to recreate the table I get the
following error:
ERROR at line
1: ORA-38301: can not perform
DDL/DML over objects in Recycle Bin
I don't remember telling this
table to go to the Recycle Bin? I
told the database to straight drop
it.
This issue obviously
involved the recycle bin, so in
order to get my nightly build to
work purged my recycle bin. To do
this I issued the following command
on my RAC database: purge
dba_recyclebin; as user sys.
I did this on both instances of
the rac. My next step is to search
Metalink and see if there is a patch
for this issue.
