for FULL database export are procedures/packages included??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: for FULL database export are procedures/packages included??

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    for FULL database export are procedures/packages included??

    hi,

    Are procedures and packages created in a database being exported in a FULL database export?? if not is there any other way that i can transfer procedures/packages from one database and import/rebuild in the other without running the scripts to recreate procedure/packages again?

    thanks

  2. #2
    Join Date
    Oct 2000
    Posts
    139
    hi
    they are exported, you can verify in utilities guide in oracle documentation

  3. #3
    Join Date
    Feb 2003
    Posts
    85
    lucky me I know where to read the docs

  4. #4
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Hence the word FULL
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  5. #5
    Join Date
    Oct 2000
    Posts
    139
    Hi

    stored procs, pgs, functions are exported at user level as well

  6. #6
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    thks for the replies...no sarcastic remarks pls
    ngwh,
    Singapore.

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by ngwh
    ...no sarcastic remarks pls

    OCP Oracle8i
    Hmmmmmmm . . . .
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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