Oracle Database Discussions

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!

Get ddl view

unknown-2698904Sep 18 2014 — edited Sep 18 2014

Hi all,

11.2.0.3.11

aix6

How do I copy the views from HR schema in PROD db to HR schema in UAT database. The are lots of them like 100+ views

I tried to run select dbms_metadata.get_ddl('VIEW','EMP' ) from dual; But the script is wrapped and splitted in half of the column name?

How do I resolve this scripting error pleasee helpppp.....

Thanks a lot,

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2014

Added on Sep 18 2014

#general-database-discussions

11 comments

502 views