RE: Synonym

There are couple of ways doing this, the logical one is to drop the public synonym that point to a.ta, since the object is no longer there; then create a public/private synonym point to b.ta for C.

Yanhua.

> -----Original Message-----
> From: ALTAIR, RSP_4 [SMTP:RSP_4.ALTAIR_at_EU.RHODIA.COM]
> Sent: Wednesday, July 05, 2000 12:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Synonym
>
> Hi all,
>
> I have a little question :
>
> If user A creates a sequence TA and creates a public synonym for it
> If user B drops sequence TA and recreates sequence TA
>
> User C wants to access the sequence, what should do user B ?
> 1. Leave the current synonym ? (i saw that if i drop a object, his
> public synonym is still here)
> 2. Recreate the synonym ?
> 3. Recreate sequence TA in A's shema ?
> 4. ?
>
> Thank you for this little precision
>
> Sebastien Boutte
>
> --
> Author: ALTAIR, RSP_4
> INET: RSP_4.ALTAIR_at_EU.RHODIA.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 05 2000 - 14:30:09 CDT