Query table structure Report "ORA-04043: Object XXX does not exist" SOLUTION

Query table structure Report "ORA-04043: Object XXX does not exist" Solve the Problem of Oracle 11.2.0 + SQL Plus + PowerDesigner 15.1 This semester to learn Oracle database application technology, need to do a course design. PowerDesigner exports SQL and imports to Oracle to query the table structure with the error ORA-04043: Object XXX does not exist. When querying the table structure, add double quotation marks. The SQL statement automatically generated by the summary tool has some problems. Therefore, we do not recommend that you use the tool to automatically generate the SQL statement. handwriting is the best way to ensure security. Operation Log [SQL] G: \ programming materials \ Learning \ Database Application Technology Oracle \ Experiment 5> sqlplus wgb SQL * Plus: release 11.2.0.1.0 Production on Tuesday June 11 09:07:05 2013 Copyright (c) 1982,201 0, Oracle. all rights reserved. enter the password: connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT * from tab;    TNAME                          TABTYPE  CLUSTERID  ------------------------------ ------- ----------  tb_class                       TABLE  tb_course                      TABLE  tb_score                       TABLE  tb_select                      TABLE    TNAME                          TABTYPE  CLUSTERID  ------------------------------ ------- ----------  tb_student                     TABLE  tb_teacher                     TABLE  tb_user                        TABLE  

You have selected 7 rows.

SQL> DESC tb_class; ERROR: ORA-04043: Object tb_class does not exist SQL> DESC tb_course; ERROR: ORA-04043: Object tb_course does not exist SQL> DESCRIBE tb_class; ERROR: ORA-04043: the tb_class object does not exist. SQL> SELECT * from tb_class 2; SELECT * from tb_class *

Row 1st error: ORA-00942: Table or view does not exist

SQL> DESC "tb_class";  

Is the name empty? Type -------- rjn_teacher_id1 NUMBER (8) n_student_id NUMBER (8) n_class_id not null number (8) vc_class_name not null VARCHAR2 (40) vc_class_col not null VARCHAR2 (30) n_course_teacher_id not null number (8)