RE: can't create any objects

From: Jackie Brock <J.Brock_at_cablelabs.com>
Date: Thu, 3 Mar 2011 14:46:17 -0700
Message-ID: <3C0068AB22D70B4DA32B9A2A965968C76FB20B13CD_at_srvxchg>

Sounds like there's likely a DDL trigger on the database...

-Jackie

Jackie D. Brock
Database Specialist - Systems Evaluation CableLabs(r)
858 Coal Creek Circle
Louisville, CO 80027
Email: j.brock_at_cablelabs.com<mailto:j.brock_at_cablelabs.com> 303-661-3347
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Thursday, March 03, 2011 2:05 PM
To: oracle-l_at_freelists.org
Subject: can't create any objects

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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 03 2011 - 15:46:17 CST