Re: can't create any objects
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: tomdaytwo <tomdaytwo@xxxxxxxxx>
- Date: Thu, 3 Mar 2011 22:09:45 +0100
My first guess would be: someone (the dba?) has created a DDL-trigger that
isn't quite bug-free yet...
In the meantime for diagnosis, you could just sql-trace your drop-table
command, and check the tracefile to see what happens behind the scenes and
causes the numeric/value error.
On Thu, Mar 3, 2011 at 10:05 PM, Thomas Day <tomdaytwo@xxxxxxxxx> wrote:
> CREATE TABLE DUMMY1(BOB VARCHAR2(2))
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-06502: PL/SQL: numeric or value error: NULL index table key value
> ORA-06512: at line 22
>
> Unfortunately I'm new at this position and they haven't gotten around to to
> giving me the CS number for a metalink account. Maybe this will light a
> fire.
>
> Anyway, can anyone shed any light on this behavior. It's 10.2.0.4.0 on
> Windows server 2003. My client is the Oracle 11g on Windows 7.
>
>
--
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
Other related posts:
