Oracle Problem Resolution: Ora-00942: Table or view does not exist

When imported from PowerDesigner into Oracle, remember to capitalize all the table names in Oracle. In the beginning, because the table name is lowercase and then the default is lowercase in Oracle, there are some very strange cases where the imported table can be seen in the list of all tables in the Enterprise Manager console. and using the table Data Editor, you can also see the imported good data, but in the concrete table space does not even see the table, it is strange, I always think that the watch exactly where to go; second, no matter in the specific table space to see, the table data can always be seen, but in sql*plus or use Plsql Developer SQL Window, write a SELECT statement to view the data, always prompt for errors: Ora-00942: The table or view does not exist. This problem began to haunt me for a long time, and later, when you import Oracle, change the table name to all uppercase (not partially capitalized), and after importing, either Sql*plus or Plsql Developer SQL window writes a SELECT statement (in which the table name is in uppercase or lowercase), Can be correctly taken out of the record.