Summary of common Oracle Database Problems and Solutions (I)

Often used in the development of Oralce database, use may encounter a variety of errors, such as: ORA-00933: SQL command is not properly ended, ORA-009242, etc, this record accumulation is very helpful for you. Today we will record some problems that have occurred before and will be supplemented later.

Error message: ORA-00942: Table or view does not exist

Figure 1-1

Figure 1-2

In the development process, use PowerDesigner to design the database and export the script. An error occurs when the script is executed. Open PowerDesigner to view the design table, if the table name is cited by "" (Figure 1-2), the query condition with double quotation marks is displayed, however, the reason why the table created by PowerDesigner is enclosed by double quotation marks is that the problem is found through other methods. The problem was solved after the modification. Specific modifications are shown in:

 

Figure 1-3

Figure 1-4

After you click "OK" to save the operation, the double quotation marks will not be displayed again. The reason for the above problem is that the table does not exist due to the lack of double quotation marks.

Figure 1-5

If you export the script again, no double quotation marks will appear.