Re: can't create any objects

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Thu, 3 Mar 2011 22:09:45 +0100
Message-ID: <AANLkTi=G3VztF3xjt=3Vo7+i73-=i=U7eJx0tsbEbkkS_at_mail.gmail.com>

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_at_gmail.com> 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_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 03 2011 - 15:09:45 CST