The Oracle database and generator database are successfully designed in powerdesigner. You can see the generated tables with PLSQL Developer, but when you add, delete and modify these tables or sequences, you will be prompted “The table or view does not exist”, direct editing is also the same prompt… It bothered me for two days, and I found a lot of information before I found the problem. It turned out that when powerdesigner generated the database, all identifiers were double quoted by default. , As a result, Oracle never distinguishes between upper and lower case, to distinguish between upper and lower case of these identifiers.
Solution:
1. Menu: Database
2. Edit Current DBMS
3. In the pop-up dialog box, set ORA11GR1::Script\Sql\Format\UpperCaseOnly to Yes
4. In the pop-up dialog box, set ORA11GR1: :Script\Sql\Format\CaseSensitivityUsingQuote is set to No
So that the above problems will not occur when the database is generated in the future.
In The Oracle database is designed in powerdesigner and the generator database is successful. You can see the generated tables with PLSQL Developer, but when you add, delete and modify these tables or sequences, it prompts “the table or view does not exist”. Direct editing is the same prompt. .. Bothered me for two days. I found a lot of information before I found the problem. It turned out that when powerdesigner generated the database, all identifiers were double quoted by default. As a result, Oracle never distinguished between case and these identifiers. Case.
Solution:
1. Menu: Database
2.Edit Current DBMS
3. In the pop-up In the dialog box, set ORA11GR1::Script\Sql\Format\UpperCaseOnly to Yes
4. In the pop-up dialog box, set ORA11GR1::Script\Sql\Format\CaseSensitivityUsingQuote to No
In this way, the above problems will not occur when the database is generated in the future.