SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

retrieve view definition from a database link

NewbieFeb 25 2013 — edited Feb 25 2013

Hi Folks,

I can able to describe view from DB link using below

desc v_emp@abc

here am getting the structure which is fine, but i want to see view definition of v_emp which is in 'abc' schema.

By using below i can retrieve my local views , here my question is how can i retrieve from 'abc' DB link?

select dbms_metadata.get_ddl('VIEW','V_EMP') from dual;

Please help me

Thanks

This post has been answered by Mihael on Feb 25 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2013

Added on Feb 25 2013

7 comments

4,151 views