OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » erroneous synonym (Oracle 10G R2 - Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

erroneous synonym [message #424979]

Tue, 06 October 2009 21:09

jcyp_71
Messages: 15
Registered: March 2009

Junior Member

Hello, is there any way to drop an erroneous synonym like this?:
/c9c9d472_TRANSCLK.

If i execute a sentence like drop synonym /c9c9d472_TRANSCLK, i get an error: synonym does not exist.

Thanks in advance.

Report message to a moderator

Re: erroneous synonym [message #424980 is a reply to message #424979]

Tue, 06 October 2009 22:00

balakrishnay
Messages: 54
Registered: September 2009
Location: Pune

Member

Hi,

Try like this ..

drop synonym " /c9c9d472_TRANSCLK";

Regards

Bala

Report message to a moderator

Re: erroneous synonym [message #424994 is a reply to message #424979]

Wed, 07 October 2009 00:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure it is an erroneous synonym and not a system one?

Regards
Michel

Report message to a moderator

Re: erroneous synonym [message #424995 is a reply to message #424994]

Wed, 07 October 2009 01:04

balakrishnay
Messages: 54
Registered: September 2009
Location: Pune

Member

Michel,

Even i had a same thought .. but i have checked in 10g DB but i dot see any synonym with that name .. jcyp_71 he should look into his DB clearly before dropping it.

Regards

Bala

Report message to a moderator

Re: erroneous synonym [message #424997 is a reply to message #424995]

Wed, 07 October 2009 01:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select synonym_name from dba_synonyms where synonym_name like '/%';
SYNONYM_NAME
------------------------------
/cc11c9d8_SerialVerFrame
/1f9f2fa_N2AFilter
/a6655642_ConstantPrinter
/8e9ef189_JavaPBinaryCode
/11444b1a_JavaPClassPrinterCod
/ae6e8237_JavaPClassPrinter
/ce47e728_JavaPEnvironment
/7ed2c8fc_RuntimeConstants
/4eaf9149_AuroraEnvironmentPai
/78e6d350_BinaryExceptionHandl
/af5a8ef3_JarVerifierStream1
/4d0ec03b_JarVerifierStream2
/744ed420_JarVerifierStreamCer
/b203c305_DateFormatZoneData1
/dedbf4e7_CompactShortArrayIte
/f390781d_CertException
...
11019 rows selected.

Regards
Michel

Report message to a moderator

Re: erroneous synonym [message #425118 is a reply to message #424997]

Wed, 07 October 2009 11:07

jcyp_71
Messages: 15
Registered: March 2009

Junior Member

Hello, in fact it's an erroneous synonym, i was tryng to create a synonym but in that moment my session was killed because of a job that executes every minute, so i need to drop it, by the way it doesn't work something like this:
drop synonym " /c9c9d472_TRANSCLK";

Thanks.

Report message to a moderator

Re: erroneous synonym [message #425124 is a reply to message #425118]

Wed, 07 October 2009 11:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>by the way it doesn't work something like this:
drop synonym " /c9c9d472_TRANSCLK";

My car doesn't work.
Tell me how to make my car go.

Does leading space character matter?
Who owns the synonym & who is trying to DROP it?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: erroneous synonym [message #425125 is a reply to message #425118]

Wed, 07 October 2009 11:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Remove the blank character at the beginning of the name.

Regards
Michel

Report message to a moderator

Previous Topic:	change storage LUN used for ASM
Next Topic:	Instance Parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 12:26:07 CST 2024