Skip to Main Content
  • Questions

  • desc command not working in SQL Developer

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Kapil.

Asked: March 08, 2018 - 12:08 pm UTC

Last updated: December 19, 2018 - 3:24 pm UTC

Version: 17.4.0.355

Viewed 10K+ times! This question is

You Asked

Hi Tom,
There are a few table on the remote server. I can't use the DESC command against these tables on SQL developer.
But when I am using SQL*Plus it is working without any error.

I can run this command against the local tables and those are on the another remote server.

Can you please help me to resolve this issue?


Thanks in advance.

Kapil

and Chris said...

There's a bug related to this. The resolution doesn't work if the DB link owner doesn't own the remote table:

select username 
from   dba_db_links
where  db_link = 'DB122';

select username 
from   dba_db_links

select * from chris.t@db122;

X   Y   
  1   1 

desc t@db122;

Name   Null?   Type         
X              NUMBER(38)   
Y              NUMBER(38)  

select * from dual@db122;

DUMMY   
X       

desc dual@db122

ERROR:
ORA-04043: object dual@db122 does not exist


You can fix this by qualifying the schema:

desc sys.dual@db122

Name    Null?   Type          
DUMMY           VARCHAR2(1)

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Nicely explained

Kapil Kumar, March 09, 2018 - 11:28 am UTC

Thanks Chris,

Any Idea whether SQL Developer team is working on it?

I forgot to mention in my questions that I am facing this issue while I am running this command against the table with DB Link.

We can use all_tab_columns for the same work but it is time taking :(

Thanks for your answer.

Kapil
Chris Saxon
March 09, 2018 - 2:51 pm UTC

I don't have any timescales for when this will be fixed.

I forgot to mention in my questions that I am facing this issue while I am running this command against the table with DB Link.

You what now?

Worked like a charm

A reader, December 19, 2018 - 3:01 pm UTC

Thank you for this post. I have been using the same DESC on the same table for some time now and this strange popped up out of nowhere...

Your post helped me to resolve my issue and get back to work!
Thanks,
Nick
Chris Saxon
December 19, 2018 - 3:24 pm UTC

Awesome :)

Review

Raghavee, January 08, 2020 - 10:45 am UTC

Thanks a lot
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.