Delete the processing after the DUAL table
The Dual Table in the Oracle system is a "mysterious" table. There are many netizens on the Internet to test the table. This table has only one row, in fact, the table and other tables in the system can perform insertion, update, delete Operation, you can also perform DROP operations. But don't perform the operation of the DROP table, otherwise it will make the system can not be used, the database can't be able to report Database Startup Crashs With ORA-1092 error.
Don't panic at this point, you can perform recovery by performing the following steps. You can log in with SYS users.
SQL> CREATE PFILE = 'D: /PFILE.BAK' from SPFILE
SQL> Shutdown Immediate
Add one in the D: /PFile.bak file: replication_dependency_tracking = false
Restart the database:
SQL> Startup Pfile = 'D: /PFILE.BAK'
SQL> CREATE TABLE "SYS". "Dual"
("Dummy" VARCHAR2 (1))
PCTFree 10 PCTUSED 4;
SQL> INSERT INTO DUAL VALUES ('x');
SQL> commit;
SQL> Grant Select on Dual to public;
Authorized success.
SQL> SELECT *.
Di
-
X
SQL> Shutdown Immediate
The database has been closed.
The database has been uninstalled.
Oracle routines have been closed.
SQL> Startup
Oracle routines have been started.
Total System Global Area 135338868 BYtes
FIXED SIZE
453492 BYTES
Variable size
109051904 BYTES
Database buffers
25165824 BYTES
Redo buffers
667648 BYTES
The database is loaded.
The database has been opened.
SQL>
OK, you can use it normally.
