take export of metadata of schema only using expdp
>expdp directory=exp_dp dumpfile=j.dmp content=metadata_only schemas=
after that create sqlfile using impdp -
>impdp directory=exp_dp dumpfile=j.dmp logfile=imp_j.log sqlfile=j.sql include=view
You can filter the views only like above, you can get everything in the schema as follows:
>impdp directory=exp_dp dumpfile=j.dmp logfile=imp_j.log sqlfile=j.sql
Brak komentarzy:
Prześlij komentarz