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

Home -> Community -> Mailing Lists -> Oracle-L -> Synonym

Synonym

From: ALTAIR, RSP_4 <RSP_4.ALTAIR_at_EU.RHODIA.COM>
Date: Wed, 5 Jul 2000 18:17:31 +0200
Message-Id: <10549.111229@fatcity.com>


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

S=E9bastien Boutt=E9 Received on Wed Jul 05 2000 - 11:17:31 CDT

Original text of this message

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