Home » RDBMS Server » Server Administration » erroneous synonym (Oracle 10G R2 - Solaris)
erroneous synonym [message #424979] Tue, 06 October 2009 21:09 Go to next message
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.
Re: erroneous synonym [message #424980 is a reply to message #424979] Tue, 06 October 2009 22:00 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi,

Try like this ..

drop synonym " /c9c9d472_TRANSCLK";

Regards

Bala
Re: erroneous synonym [message #424994 is a reply to message #424979] Wed, 07 October 2009 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure it is an erroneous synonym and not a system one?

Regards
Michel
Re: erroneous synonym [message #424995 is a reply to message #424994] Wed, 07 October 2009 01:04 Go to previous messageGo to next message
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
Re: erroneous synonym [message #424997 is a reply to message #424995] Wed, 07 October 2009 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: erroneous synonym [message #425118 is a reply to message #424997] Wed, 07 October 2009 11:07 Go to previous messageGo to next message
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.
Re: erroneous synonym [message #425124 is a reply to message #425118] Wed, 07 October 2009 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: erroneous synonym [message #425125 is a reply to message #425118] Wed, 07 October 2009 11:25 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove the blank character at the beginning of the name.

Regards
Michel
Previous Topic: change storage LUN used for ASM
Next Topic: Instance Parameter
Goto Forum:
  


Current Time: Wed Dec 07 23:59:20 CST 2016

Total time taken to generate the page: 0.08758 seconds