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


PROBLEM :

Connecting with sqlplus you get:

bash-3.2$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 21 15:42:49 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn SD_CON/SD_CON;
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.

SOLUTION

To determe if you are falling in the scenario here described just issue:

SQL> column OWNER format a15;
SQL> column OBJECT_NAME format a20;
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED 
 2 from dba_objects 
 3 where object_name='DUAL';

OWNER OBJECT_NAME OBJECT_TYPE CREATED
--------------- -------------------- ------------------- ---------
SYS DUAL TABLE 25-SEP-11
PUBLIC DUAL SYNONYM 25-SEP-11
SD_CON DUAL TABLE 25-SEP-15

There is a private 'DUAL table.
 
 You can drop or rename the 'BAD' table after checking with the owner what are 
 the reasons to have that special table in a user schema.


bash-3.2$ export ORACLE_SID=AZKKTST
bash-3.2$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 21 15:59:44 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from SD_CON.DUAL
 2 ;

no rows selected

SQL> DROP TABLE SD_CON.DUAL CASCADE CONSTRAINTS;

Table dropped.

SQL> conn SD_CON/SD_CON
Connected.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: