1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle importing Procedure packages

Discussion in 'Server Administration and Options' started by hisham_oracle, Jul 23, 2010.

  1. hisham_oracle

    hisham_oracle Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi, any body knows how to import packages .dmp file into database?
    i tried the normal import way but i wasnt succeful..

    any suggestions?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Show us your 'normal' way and maybe we can help you.
     
  3. hisham_oracle

    hisham_oracle Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    cmd

    c:\> imp u/p file= c:\test.dmp full= y
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What errors are you seeing?
     
  5. hisham_oracle

    hisham_oracle Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    hi,

    packages were succesfully imported, but now i am facing this error when trying to select from any table:

    "policy predicate has error"

    please advice
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You have an error in a fine-grained auditing predicate that needs to be fixed. Consult the documentation for the DBMS_FGA package to see how to modify such predicates.