SQL Developer (MOSC)

MOSC Banner

Info command not working properly while desc command work as expected.

in SQL Developer (MOSC) 18 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center