Home » RDBMS Server » Server Administration » Status Invalid for Synonym (10.2.0.2.0)
Status Invalid for Synonym [message #298162] Tue, 05 February 2008 03:33 Go to next message
harshasp
Messages: 1
Registered: February 2008
Location: Bangalore
Junior Member
How to make the status of the synonym Invalid from Valid.
It can be done by running "utlrp.sql"
Let me know how it can be done for a single Synonym.
I want to change the status of a single synonym from invalid to VALID.

Re: Status Invalid for Synonym [message #298164 is a reply to message #298162] Tue, 05 February 2008 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recreate the object pointed by the synonym.

Regards
Michel
Re: Status Invalid for Synonym [message #302137 is a reply to message #298162] Sat, 23 February 2008 22:21 Go to previous messageGo to next message
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
Junior Member
if the synonym is private

ALTER SYNONYM OWNER.SYNONYM_NAME COMPILE


If the synonym is public

ALTER PUBLIC SYNONYM SYNONYM_NAME COMPILE
Re: Status Invalid for Synonym [message #302141 is a reply to message #302137] Sun, 24 February 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
These commands do not exist.
Please at least verify your command exists and is syntaxically correct before posting.

Regards
Michel
Re: Status Invalid for Synonym [message #302159 is a reply to message #302141] Sun, 24 February 2008 04:43 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm?
SQL> select * From v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> alter public synonym brisime compile;

Synonym altered.

SQL> alter synonym rev compile;

Synonym altered.

SQL>
Re: Status Invalid for Synonym [message #302160 is a reply to message #302159] Sun, 24 February 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Doh! Embarassed
Never rely on documentation. Even 11g one does not mention it.

Thanks for the correction.
Regards
Michel
Re: Status Invalid for Synonym [message #302186 is a reply to message #302160] Sun, 24 February 2008 15:24 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Michel Cadot
Never rely on documentation.

/forum/fa/449/0/
Previous Topic: adding online redo logfile group
Next Topic: ORA-01114
Goto Forum:
  


Current Time: Mon Sep 16 05:53:44 CDT 2024