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!
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
/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With