RE: ORA-1041 Host def extension does not exist...

Start with the Oracle Errors manual:

ORA-01401 inserted value too large for column Cause: The value entered is larger than the maximum width defined for the column.
Action: Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width.

It appears that something in the batch job is trying to put a value into a column that is too large for the column. Which table is affected?
What are its columns?
What values are being inserted into the columns?

Thomas L. Harleman
Oracle Troubleshooter
11080 Willowmere Dr.
Indianapolis, IN 46280
317-843-9122
tharleman_at_iquest.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Janardhana Babu
Sent: Friday, May 05, 2000 1:03 PM
To: Multiple recipients of list ORACLE-L Subject: ORA-1041 Host def extension does not exist...

Dear list,

One of my analyst is reporting that she is getting thousands of the following error messages in her logfile while running a batch job. The Oracle version is 8.1.5 (64 bit) on HP-UX 11.0. I do not know how to approach to solve this problem. Any clues would be greatly appreciated.

ERROR:
ORA-01041: internal error. hostdef extension doesn't exist

SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0 Unable to proceed

Thanks,
-- Janardhana Babu

--
Author: Janardhana Babu
  INET: jbdonga_at_ucdavis.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).