Re: how can I get public synonym scripts without referencing dba_synonyms ?

From: Robert Prendin <rprendin_at_magi.com>
Date: Sun, 12 Apr 1998 04:25:50 GMT
Message-ID: <353043a9.823456938@news.istar.ca>

You could try something like this

SET PAGESIZE 0
SET FEED OFF
SPO CRE_SYNS.SQL select 'create public synonym '|| synonym_name ||' for ' ||table_owner||'.'||table_name||';' from dba_synonyms

where 	owner = 'PUBLIC' 
and 	table_owner not in ('SYS','SYSTEM');

SPO OFF @CRE_SYNS SET FEED ON
SET PAGESIZE 1000 Robert Prendin

jdlee <jdlee_at_trigem.co.kr> wrote:

>as you know , we can get "create table, index, grants related scrits "
>using exp tool .
>
> for example ' exp scott/tiger indexes=y grants=y rows=n show=y '
>
>but how can I get public synonym scripts ?
>I want to get complete public synonym script
>
>not referencing to dba_synonyms
>without editing efforts.
>
> anyone knows easy method ?
>
>
Received on Sat Apr 11 1998 - 23:25:50 CDT