Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DESCRIBE via database link?

Tags:

sql

oracle

I tried to execute the DESCRIBE command via a database link, but this was the return message:

DESCRIBE <table>@<database>;
ERROR:                               
------------------------------------ 
ERROR: object <table> does not exist 

1 rows selected

A SELECT on this table works well.

Does Oracle permitts DESCRIBE via a database link?

I'm using the Oracle SQL Developer 1.5.1.

Edit:

Is there another option to describe a table?

Thanks in advance!

like image 665
guerda Avatar asked Jan 30 '09 13:01

guerda


1 Answers

The easiest way to get the description of a table on a remote server would be:

CREATE OR REPLACE VIEW TMP_VIEW AS SELECT * FROM TABLE_A@SERVER
/
DESCRIBE TMP_VIEW
/
like image 59
user34850 Avatar answered Sep 18 '22 13:09

user34850