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

Error was 1041 and not 1401 :-(

For 1041 errors, contact Oracle Support. Search Metalink. There is a note on this error.

• Kirti

> -----Original Message-----
> From: Thomas Harleman [SMTP:tharleman_at_iquest.net]
> Sent: Friday, May 05, 2000 2:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> Babu
> Sent: Friday, May 05, 2000 1:03 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
> --
> Author: Thomas Harleman
> INET: tharleman_at_iquest.net
>
> 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
Received on Fri May 05 2000 - 14:37:57 CDT