PowerDesigner export SQL, import to Oracle query table structure report ORA-04043: Object XXX does not exist solved

A course design is required to study Oracle database application technology this semester. PowerDesigner export SQL, import to Oracle to query the table structure reports ldquo; ORA-04043:

A course design is required to study Oracle database application technology this semester. PowerDesigner export SQL, import to Oracle to query the table structure reports ldquo; ORA-04043:

Environment

Oracle 11.2.0 + SQL Plus + PowerDesigner 15.1

Problem

A course design is required to study Oracle database application technology this semester. PowerDesigner exports SQL and imports to Oracle to query the table structure with the error ORA-04043: Object XXX does not exist.

Solution

Double quotation marks are added to query the table structure.

Summary

The SQL statement automatically generated by the tool has some problems, so I do not recommend that you use the tool to automatically generate the SQL statement. handwriting is the best way to ensure that nothing is lost.

Operation Log

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:
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: the object tb_class does not exist

SQL> DESC tb_course;
ERROR:
ORA-04043: the object tb_course does not exist

SQL> DESCRIBE tb_class;
ERROR:
ORA-04043: the object tb_class does not exist

SQL> SELECT * from tb_class
2;
SELECT * from tb_class
*
Row 3 has an error:
ORA-00942: Table or view does not exist

SQL> DESC "tb_class ";
Is the name empty? Type
-----------------------------------------------------------------------------

N_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)

References

Oracle ORA-04043: a condition in which the object *** does not exist