Taking Export without Materialized Views
Is there any way we can take export of a schema without materialized views.
We want to replicate one schema from one server to another without materilaized views. The Schema size around 800G.
Export allows you to identify which specific tablespaces you want to export.
Hope you have your MVs and other non-wanted objects in separate tablespaces.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width