Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PUBLIC synonyms

Re: PUBLIC synonyms

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 01 Jul 2002 23:14:12 +0100
Message-ID: <3D20D434.6DED@yahoo.com>


Phil Condit wrote:
>
> How does one export all synonyms created by a particular user?
>
> Thanks

Its relatively straightforward to build an SQL using xxx_SYNONYMS, or running an export with rows=n and simply grep-ing for SYNONYM.

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Mon Jul 01 2002 - 17:14:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US