On Apr 22, 12:51 am, Mayank <mayank.del...@gmail.com> wrote:
> I have 1000 triggres out of this i need to take 700 selective trigers
> backup.coupl you pls tell me the way so that i can mininze the
> complexity of talking selective triggre backup.
>
> Is there is a best way to do this.....?
>
> Thanks In Advance.
>
> Best Regards
> Mayank
Why do you need 70% of your triggers backed up? Are the other 30% not
important? The exp utility will copy all of them so, in essence, they
will all be 'backed up' for you. Other than running a query against
the USER_TRIGGERS view for the selected triggers you feel need to be
'backed up', or using the dbms_metadata.get_ddl function to return the
code for those triggers, you cannot use exp or RMAN to selectively
'back up' a subset of your triggers.
I don't understand the 'requirement'. Possibly you could better
explain why you ask this question.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
