Re: dbms_metadata for Synonym

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,
>
> 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.
>
Hari

--
Posted via http://dbforums.com