Can any one advise me how to export and import only triggers
Please help
Printable View
Can any one advise me how to export and import only triggers
Please help
Sure, I can advise you. It can't be done.
just get the source from user/dba_triggers
I once had a dog named trigger
A dog?Quote:
Originally posted by stmontgo
I once had a dog named trigger
Did you have a Lone Ranfer complex?
Parents wouldn't get you that pony as a kid huh?
I once had a trigger named DOG...Quote:
Originally posted by stmontgo
I once had a dog named trigger
exp with rows=N
imp system tables=blah ignore=y rows=n constraints=y grants=n indexes=n
:confused: So you miss the triggers on non-existant tables?Quote:
Originally posted by Axr2
You will get the triggers on the table if the table exists.
BTW, I know a guy call Dog.
> So you miss the triggers on non-existant tables?
Okay, you got me on a technicality. You know the answer.
;)