DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: export/imp -triggers

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    export/imp -triggers

    Can any one advise me how to export and import only triggers

    Please help

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, I can advise you. It can't be done.
    Jeff Hunter

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    just get the source from user/dba_triggers

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    I once had a dog named trigger
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by stmontgo
    I once had a dog named trigger
    A dog?
    Did you have a Lone Ranfer complex?
    Parents wouldn't get you that pony as a kid huh?
    I remember when this place was cool.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by stmontgo
    I once had a dog named trigger
    I once had a trigger named DOG...
    Jeff Hunter

  7. #7
    Join Date
    Oct 2002
    Posts
    807
    exp with rows=N

    imp system tables=blah ignore=y rows=n constraints=y grants=n indexes=n
    Last edited by Axr2; 07-12-2004 at 03:21 PM.

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Axr2
    You will get the triggers on the table if the table exists.
    So you miss the triggers on non-existant tables?

    BTW, I know a guy call Dog.

  9. #9
    Join Date
    Oct 2002
    Posts
    807
    > So you miss the triggers on non-existant tables?

    Okay, you got me on a technicality. You know the answer.

  10. #10
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

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