Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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,
That would require selecting from dba_dependencies. Since your dependencies may have their own dependencies that query would probably need to be recursive.
Also, if any of the dependencies are in a different schema then you'll also need the grants to go with them which you can get by selecting from dba_tab_privs and dba_col_privs.
git checkoutat the command prompt. If you are using SQLDeveloper, use the Cart feature.