I have managed to figure out the solution for the 1st one. All I had to
do was set filter to the current schema. So please just consider the
2nd problem:
2. when generating triggers, certain triggers are not being extracted
completely. I repeat only certain triggers. rest of them are being
extracted ok. can someone please explain why this is happening and
how can i avoid it?
Thanks,
Hari
Originally posted by wallflowers
Hi,Hari
I am using dbms_metadata for generating all the ddl in the current
schema. Although there are a couple of problems i am facing.
1. when i try to generate the ddl for all synonyms, it seems to be
generating the ddl for all public synonyms, i need only the ones
owned by the current schema. how do i do that?
2. when generating triggers, certain triggers are not being extracted
completely. I repeat only certain triggers. rest of them are being
extracted ok. can someone please explain why this is happening and
how can i avoid it?
Any help is highly appreciated. Thanks in advance.
--
Posted via http://dbforums.com