Re: how can I get public synonym scripts without referencing db

From: Ronald <_ronr__at__wxs.nl_>
Date: Sat, 11 Apr 1998 15:44:41 +0200
Message-ID: <B1554069966834BB0@ut0241.wxs.nl>

In article <352EE75F.D185B47A_at_trigem.co.kr>, jdlee <jdlee_at_trigem.co.kr> wrote:

>Subject: how can I get public synonym scripts without referencing dba_synonyms ?
>From: jdlee <jdlee_at_trigem.co.kr>
>Organization: Inet Internet Service
>Date: Sat, 11 Apr 1998 12:45:36 +0900
>Newsgroups: comp.databases.oracle.misc
>
>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 ?
>
>

Not sure. but how about exporting user public ?

Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: dec 31, 1997) Received on Sat Apr 11 1998 - 08:44:41 CDT