Info command not working properly while desc command work as expected.
I am having an issue using INFO command in SQLcl SQLcl: Release 24.1 and SQL Developer Version 23.1.0.097 ,Build 097.1607. However, DESC command works for the same object.
Here is the test case:
SQL> create table test_1 as select * from dba_objects where 1 = 0;
Table TEST_1 created.
SQL> create table customer.test_1 as select * from dba_objects where 1 = 0;
SQL> select OWNER, OBJECT_NAME from dba_objects where object_name = upper('test_1');
OWNER OBJECT_NAME
—————- ———————-CUSTOMER TEST_1
MCHANG TEST_1
SQL> INFO CUSTOMER.TEST_1
ERROR:
ORA-04043: object CUSTOMER.TEST_1 does not exist
SQL> info TEST_1
TABLE: TEST_1
LAST ANALYZED:
ROWS :
SAMPLE SIZE :
INMEMORY :DISABLED