Re: Create Oracle users!!!

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0110160120.46d11c36_at_posting.google.com>...
> marianmanole_at_hotmail.com (Marian Manole) wrote in message news:<ab52679d.0110150814.10429ff_at_posting.google.com>...
> > Hi all,
> >
> > I have a great problem:
> > I utilise a Oracle database 8.1.6 (french version) over a W2000
> > Server!
> > I want create a new user from SQLPLUS but I can't!!!
> >
> > I do that:
> >
> > connect system/manager_at_base
> > create user titi identified by titi default tablespace users temporary
> > tablespace temp;
> >
> > And I receive that message:
> >
> > "a error is produced at SQL recursiv level 1"
> > "format date is very big than internal cache memory"
> > (sorry if my traduction isn't very good)
> >
> > What can I do?
> >
> > Thanks in advance!
>
> Either :
> set NLS_LANG to American_America.WE8ISO8859P1 temporarily, repeat the
> operation and post the result
> or
> post the French error message.
> It doesn't come near any error I know.
>
> Regards,
>
>
> Sybrand Bakker
> Senior Oracle DBA

Hi,
The message is:

"create user titi identified by titi default tablespace users temporary tablespace temp
*
ERREUR à la ligne 1 :
ORA-00604: Une erreur s'est produite au niveau SQL récursif 1 ORA-01801: format date trop grand par rapport à la mémoire tampon interne "

Specifications:
My base it's a learning database for developpers! It's a default database created automaticaly after the installation!

Best regards,
Marian Manole
Ingenieur d'etudes
CGBI Group - FRANCE Received on Thu Oct 18 2001 - 10:09:19 CEST