Hi, I want to export full database but exclude functions and procedure during export.
Does oracle provide any parameter to perform this task.
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.
One of the two things I have learned as a DBA is to always take more then you need with an export.
Always better to have too much then too little.
I remember when this place was cool.
You can always drop unwanted procedures, functions, packages, etc after import. You can also revoke CREATE PROCEDURE and specify ignore=Y during the import process. You would then grant CREATE PROCEDURE after the import.
this space intentionally left blank
...assuming you're doing a fromuser/touser import. importing with a user (such as system) that has CREATE ANY PROCEDURE will still create the procedures.
Originally Posted by gandolf989
Data Pump Export
EXCLUDE=PACKAGE, FUNCTION, PROCEDURE will exclude all packages, functions, and procedures associated with this export.
check this link..
Click Here to Expand Forum to Full Width