DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2000

    import everything except the triggers!!

    I did a full export of the database with the new export utility from 10g.

    expdp userid=sys dumpfile=full.dmp full=y

    When i imported in a new database. Everything was ok, except the owners dont have any table triggers

    impdp userid=sys dumfile=full.dmp full=y
    impdp userid=sys dumfile=full.dmp schemas=demo40

    Both commands did not import the table trigger.

    Is there a way to import only the trigger?
    Why this happened?

    Note: I did this with
    I patched the database to this weekend.

    Do you think the patched version will import the triggers?

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    Were the triggers owned by the same user as the tables, and have you checked that they were contained in the export file?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2000
    The trigger are owned by the user.

    The first 2 import i did where fine. I imported it with the user sys.

    The other import did not imported the triggers. I did not imported with the user sys. Another user, that may not have every privilege to import.

    So if i try to re-import with the user sys, the triggers still wont import. How can i say the impdp utility to just import the triggers?

  4. #4
    Join Date
    Nov 2000

  5. #5
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Quote Originally Posted by steeve123
    How can i say the impdp utility to just import the triggers?
    Take a look at the INCLUDE parameter of the impdp.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Nov 2000
    Thanks: include=trigger worked

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.