OraFAQ Forum: SQL & PL/SQL » cannot describe table via a dblink

Home » SQL & PL/SQL » SQL & PL/SQL » cannot describe table via a dblink

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cannot describe table via a dblink [message #236324]

Wed, 09 May 2007 10:56

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

Help

This is weird. I create table A in my database, I create a public synonum A for this table. I log into a remote database and select records from my table (table A). Its fine, I can select records. But, if I try to describe this table I get nothing. Cannot describe this table via a dblink. Any ideas why?

Report message to a moderator

Re: cannot describe table via a dblink [message #236326 is a reply to message #236324]

Wed, 09 May 2007 11:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Any ideas why?
Implementation limitation which is version dependent, IIRC.

Report message to a moderator

Re: cannot describe table via a dblink [message #236327 is a reply to message #236326]

Wed, 09 May 2007 11:07

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

Oracle 9i. If I do DESCRIBE USER.TABLE@DB_LINK I can describe the table. But if I do DESCRIBE TABLE@DB_LINK I get no description? Why? If there is a public synonym created on the table and I can select as follows just fine: SELECT * FROM TABLE@DB_LINK without specifying the user?

Report message to a moderator

Re: cannot describe table via a dblink [message #236329 is a reply to message #236324]

Wed, 09 May 2007 11:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I can sell you a bridge if that would help you to get over it.
It is what it is.
If it bothers you enough, file a Service Request with Oracle.
Keep in mind that DESCRIBE is a SQL*Plus command & not part of the SQL standard language.

Report message to a moderator

Re: cannot describe table via a dblink [message #236332 is a reply to message #236329]

Wed, 09 May 2007 11:42

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

umm...nothing to get over, I was just wondering why I had to specify the user when I describe a table via a dblink. If that is what that is then be it..I think therefore I am Smile

Anyways, thank you for your kind response.

Report message to a moderator

Previous Topic:	needed order by in concat_all() function
Next Topic:	external tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 26 23:32:51 CST 2026