The table exists clearly. The deletion times: the table or view does not exist ~! Row 1st error: ORA-00942: Table or view does not exist later I finally figured out the reason because my table name is lower case
The table exists clearly. The deletion times: the table or view does not exist ~! Row 1st error: ORA-00942: Table or view does not exist later I finally figured out the reason because my table name is lower case
The table exists clearly. The deletion times: the table or view does not exist ~!
Row 3 has an error:
ORA-00942: Table or view does not exist
I finally figured out the reason because my table name is in lower case, but in upper case, this problem will not occur.
Under normal circumstances .... the data in the data dictionary is in uppercase, and the dynamic view is in lowercase ........ use "" when using keywords for table or other object names ""
The table name is caused "".
When a table is deleted, cascade constraints deletes the related CONSTRAINTS.