SP2-0575 Use of Oracle SQL feature not in SQL92 Entry Level.

[azulita]

Hello,

I have a problem when I try to connect to sqlplus...

sqlplus system

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Aug 29 11:22:26 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Could you helpme please....

Thanks.... =)

 

[SantaMufasa]

Little Blue,

Since every Oracle users must have a password, what happens when you enter the "password" for the SYSTEM user when it asks for the password?


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[johnherman]

SP2-0575 Use of Oracle SQL feature not in SQL92 Entry |Intermediate|Full Level

Cause: A SQL statement was attempted that is not FIPS compliant. This error may also occur if a SQL*Plus feature, for example SET AUTOTRACE, that uses SQL specific to Oracle was turned on when using FIPS flagging.

Action: Use SET FLAGGER, and turn FIPS compliance checking OFF, or rewrite the statement.


From:

http://otn.oracle.com/pls/db92/db92.homepage?remark=tahiti

A great link !



-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[azulita]

Hi,

This problem is with system and others users but not with sysdba.

I read (Use SET FLAGGER, and turn FIPS compliance checking OFF, or rewrite the statement)

But is not clear for me.

=(

Thanks