RE: can't create any objects

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 3 Mar 2011 16:12:34 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F6835B622_at_AAPQMAILBX02V.proque.st>

Hmm..going to be tough without Oracle support. You might try enabling sql_trace and re-running the command. That may show you specifically where the error is originating....

-Mark

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Thursday, March 03, 2011 4: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:12:34 CST