Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    12

    Exclamation Unanswered: exp procedure from one schema to another

    hi,
    how to export only stored procedure from one schema to another which is in encripted format.
    thanks ,

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    If by encrypted you mean wrapped, then you can exp/imp same as any other procedure.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Assuming they're on the same versions, LKBrwn is right... imp/exp all you like without problems.

    Code wrapped using 9i wrap.exe cannot be imported/executed on 8 (but I don't know if this stands the other way round - haven't tried it).

    I also don't know if minor versions (8.1.7 vs 8.1.6) also had wrapping (encryption) changes.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •