-
Export
Hi, I want to export full database but exclude functions and procedure during export.
Does oracle provide any parameter to perform this task.
thanks,
-
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.
-
Originally Posted by gandolf989
You can also revoke CREATE PROCEDURE and specify ignore=Y during the import process. You would then grant CREATE PROCEDURE after the import.
...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.
Jeff Hunter
-
Data Pump Export
EXCLUDE=PACKAGE, FUNCTION, PROCEDURE will exclude all packages, functions, and procedures associated with this export.
check this link..
http://www.oracle-training.cc/10g_17_27a.htm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|