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

SQL> CLEAR SCREEN;
# Create a database table
SQL> start e: \ SQL. SQL;
18;

The table has been created.

SQL> select table_name, tablespace_name from user_tables;

TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------
TB_MTBasicInfo DBDATAFILESPACE

# DBDATAFILESPACE
SQL> select tablespace_name from user_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
DBDATAFILESPACE
DBINDEXSPACE

You have selected 7 rows.

# Login Username: DBMATERIALOWNER
SQL> select username from user_users;

USERNAME
------------------------------
DBMATERIALOWNER

# DBA identity
SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE adm def OS _
---------------------------------------------------------------------
DBMATERIALOWNER DBA NO YES NO

# The table object does not exist.
SQL> desc TB_MTBasicInfo;
ERROR:
ORA-04043: the object TB_MTBasicInfo does not exist


SQL> desc DBDATAFILESPACE. TB_MTBasicInfo;
ERROR:
ORA-04043: the object DBDATAFILESPACE. TB_MTBasicInfo does not exist



E: \ SQL. SQL content:
Create table "DBMATERIALOWNER". "TB_MTBasicInfo "(
"MT_ID" NUMBER (10, 0 ),
"MT_CODE" VARCHAR2 (50 BYTE) not null,
"MT_DESC" VARCHAR2 (600 BYTE) not null,
"MT_5497_CODE" NVARCHAR2 (50) not null,
"MT_5497_DESC" NVARCHAR2 (150 ),
"MT_PROD_CODE" NVARCHAR2 (50 ),
"MT_PROD_DESC" NVARCHAR2 (150 ),
"MT_SPEC_APPR" NVARCHAR2 (100 ),
"MT_BATCH_NO" NVARCHAR2 (50 ),
"MT_TYPE_CODE" NVARCHAR2 (50) not null,
"MT_TYPE_DESC" NVARCHAR2 (150) not null,
CONSTRAINT TB_MTBasicInfo PRIMARY KEY
(
MT_ID
)
)
 
In the original command line, if a table is created with quotation marks, quotation marks will also be used. If the command is as follows:
 
Desc "DBDATAFILESPACE". "TB_MTBasicInfo"
 
There will be no problems.
 
It is case sensitive when it comes to quotation marks.