Re: how to export public synonyms from one to another oracle database

Tom wrote:
> I need to export public synonyms from one to another oracle database.
>
> Since public synonyms are logical objects and owner 'PUBLIC' is also logical
> a can't export those
> owner through exp/imp utility..
> example
> exp system/manager_at_pro.proliant from user = <public>
> file=public_synonims.dmp
>
> any idea???
>
>

Don't - create a script instead.

-- 
Regards,
Frank van Bortel