Oracle Database reports a bug. the table or view does not exist. The table name contains spaces.

Oracle Database reports a bug. the table or view does not exist. The table name contains spaces. 1. start: the fields in the SQL code exported through powderDesiger are in lower case, and then oracle.2.bug is imported directly: The table structure cannot be modified (in PL/SQL Developer) --- including adding deletion and modification... 3. [html] indicates that the table exists. If you delete it, the table or view does not exist ~! Row 1st error: ORA-00942: The table or view does not exist www.2cto.com and then finally finds 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 ........ when using keywords for the name of a table or other objects, you can use "" So the table name is "to solve this problem. When Using cascade constraints to delete a table, you will apply the CONSTRAINTS related to the table. you can use a select statement to query the tables to be deleted, the Code is as follows: [html] -- query the foreign key constraint select 'alter table' | TABLE_NAME | ''| 'drop constraint' |'' | CONSTRAINT_NAME | '; 'From user_constraints where CONSTRAINT_TYPE = 'r' and TABLE_NAME like 'ta/_ % 'escape '/'; -- Query table name select 'drop table' | TABLE_NAME | ''| ';' from user_tables where TABLE_NAME like 'ta/_ % 'escape'/'; www.2cto.com 2. 1. when a table is generated, the table name is not checked. You can directly create the table. As a result, the table has both primary keys and Foreign keys. You cannot delete the table because of double quotation marks. fix the bug, invalid character, or bug3. the TABLE or view does not exist. Change the TABLE name and delete the [html] Code: alter table "TBL_CERT IFICATE _ TYPE" rename to "TABLE2 "; here, double quotation marks cause the table name. The double quotation marks here are different from the previous double quotation marks. The previous double quotation marks lead to a lower-case table name, which leads to a non-consecutive table name.