DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Export

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    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,

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Nope
    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.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote 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

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    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
  •  


Click Here to Expand Forum to Full Width