[Oracle] 沒事別亂drop dual table

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 13:33:39 2008

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

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

 

SQL> drop table dual;

Table dropped.

 

SQL> shutdown

 

Database closed.

 

Database dismounted.

 

ORACLE instance shut down.

 

SQL> startup

 

ORACLE instance started.

Total System Global Area  188743680 bytes

Fixed Size                  1286460 bytes

Variable Size              96472772 bytes

Database Buffers           88080384 bytes

Redo Buffers                2904064 bytes

Database mounted.

 

ORA-01092: ORACLE instance terminated. Disconnection forced

 

SQL>

 

如何重建?

 

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