Sample Header Ad - 728x90

Oracle 12cR2 - How To Create DDL Script Of A View With All Dependencies and Permissions

0 votes
1 answer
286 views
I have a view in my production database and I want to create same view in my test database. I tried this commmand: ‌‌select dbms_metadata.get_ddl('VIEW','VIEW_NAME','VIEW_OWNER') from dual; It generated a create script and I run it. But it didn't copy all of the dependencies, data types, etc. How can I do this? Regards,
Asked by jrdba (55 rep)
Aug 12, 2020, 11:40 AM
Last activity: May 17, 2025, 09:05 PM