The name of the table generated by powerdesigner is enclosed in quotation marks as follows: /* ===================================================== ======================================= */ /* Table: "eppd_ B _bill_intercalate "*/ /* ===================================================== ======================================= */ Create Table "eppd_ B _bill_intercalate "( Material_price_id varchar2 (32) not null, Constraint pk_eppd_ B _bill_intercalate primary key (material_price_id) ) / Comment on column "eppd_ B _bill_intercalate". material_price_id is 'Material price ID (cljgmcid )' / That is, the table name is changed to the expected table name eppd_ B _bill_intercalate plus quotation marks "eppd_ B _bill_intercalate" The main cause of this problem is that the corresponding PDM file contains lowercase letters in the corresponding table name, and Oracle should be uppercase letters by default, so it will be marked with quotation marks. For example, if the name of the table in PDM is "eppd_ B _bill_intercalate", ill is lowercase. There are two solutions: First, replace all the table names with uppercase letters, and change ill to eppd_ B _bill_intercalate. The second is that it takes a long time to change a large number of tables of this type. You can consider canceling the default identifier. The cancellation method is Select database-> edit current database and select SQL-> Format. There is a casesensitivityusingquote. Its comment is "determines if the case sensiti.pdf for identifiers is managed using double quotes ", indicates whether double quotation marks are used to specify the case sensitivity of the identifier. You can see that the default value of values on the right is "yes" and changed to "no". Click "OK. In the displayed dialog box, click OK. In this way, the script is generated again after saving, and no quotation marks are generated. |