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

Thread: import everything except the triggers!!

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    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 10.2.0.1
    I patched the database to 10.2.0.2.0 this weekend.

    Do you think the patched version will import the triggers?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    Posts
    440
    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
    Posts
    440
    Anyone?

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    http://download-uk.oracle.com/docs/c....htm#sthref308
    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
    Posts
    440
    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