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

Home -> Community -> Usenet -> c.d.o.server -> Problem Creating User

Problem Creating User

From: Dean Mah <dmah_at_members.evolt.org>
Date: 1 Apr 2002 08:12:14 -0800
Message-ID: <cdb20477.0204010812.755d7d47@posting.google.com>


About a two weeks ago, we started getting the following error message when trying to do "CREATE USER test IDENTIFIED BY test;" in SQL*Plus:

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01400: cannot insert NULL into ("SYS"."USER$"."ASTATUS")

anybody seen this error before? Any fixes?

The server is Linux 2.4.14 and the database is Oracle8i Release 8.1.6.1.0.

Thanks,
Dean Received on Mon Apr 01 2002 - 10:12:14 CST

Original text of this message

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