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

Source: Internet
Author: User


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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.