Oracle SQL feature not in SQL92 Entry Level

[feroz]

hi,

oracle 8.0.6
ncr unix

I'm trying to use SQL PLUS from command line. After I entered my username and password, I received this statement "Use of Oracle SQL feature not in SQL92 Entry Level". Then I got to SQL> prompt. Anybody could explain to me the meaning of this statement please? And how to overcome this statement?

Am I missing something in Oracle environment or what? Thank you in advance for your help.

regards,
feroz

[defraine]

It is possible that either the table SYS.dual does not have 1 row (it should always have 1) or that you have some other objects named "dual". Try querying dba_objects where object_name = 'DUAL'. If there is another object besides sys.dual, rename or drop it.