Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ora-01400: missing info for schema.table.column

ora-01400: missing info for schema.table.column

From: Thomas Blankschein <thomas_at_blankschein.de>
Date: Fri, 03 Mar 2006 02:58:31 +0100
Message-ID: <4407a2ca$0$22077$9b4e6d93@newsread2.arcor-online.net>


Hello,

[Oracle 9.2.0.6]

when USER_B tries an INSERT INTO USER_A.TAB and some NOT NULL values are missing, he gets a ORA-01400. But in the error text the information about schema, table and column are missing:

ORA-01400: cannot insert NULL into ()

So the error message is not very useful because all the important info ist missing. What's wrong here? Has it something to do with missing grants on the data dictionary?

Thanks,
Thomas Received on Thu Mar 02 2006 - 19:58:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US