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?