-->

Spiga

Dual Dropped and Recreation..

SQL> DROP TABLE SYS.DUAL ;

Table dropped.

SQL> CREATE TABLE SYS.DUAL
2  (
3    DUMMY  VARCHAR2(1 BYTE)
4  )
5  TABLESPACE SYSTEM;

Table created.

SQL> CREATE PUBLIC SYNONYM DUAL FOR SYS.DUAL;

Synonym created.

SQL> GRANT SELECT ON SYS.DUAL TO PUBLIC WITH GRANT OPTION;

Grant succeeded.

SQL> INSERT INTO dual VALUES ('X');

1 row created.


SQL> SELECT * FROM dual;

D                                                                               
-                                                                               
X  

There was an error in this gadget