Home » SQL & PL/SQL » SQL & PL/SQL » synonyms parameter (Developer 6i, Databse 11G R2,window 7 ultimate)
synonyms parameter [message #634123] Wed, 04 March 2015 12:43 Go to next message
kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Hello,Please assist

When creating synonyms there is an option of entering parameter--

#create or replace synonym XZ for &1..PLANED_EVENTS.My question is, is it possible to enter parameter &1.. before or after all the synonyms have been created?

Thank you.

Report message to a moderator

Re: synonyms parameter [message #634124 is a reply to message #634123] Wed, 04 March 2015 12:50 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
What do you want the parameter to do? You are not clear at all.

Report message to a moderator

Re: synonyms parameter [message #634129 is a reply to message #634123] Wed, 04 March 2015 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

This question is completely meaningless.
The synonym depends on a parameter you want to enter after the synonym is created?

Report message to a moderator

Re: synonyms parameter [message #634130 is a reply to message #634129] Wed, 04 March 2015 13:35 Go to previous messageGo to next message
kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Hello

Thank you all.The thing is ,I have 1000 synonyms to create each time i'm doing re-installation.When creating one I have to provide the belonging schema first e.g Scott.So instead of providing belonging schema for 1000 synonym,is there a way to provide it just once ?

Report message to a moderator

Re: synonyms parameter [message #634132 is a reply to message #634130] Wed, 04 March 2015 13:52 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

@myscript SCOTT

Report message to a moderator

Previous Topic: complete refresh of materialized view works fine, but non-complete doesn't
Next Topic: Which system table I can check these grants available in my database or not?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 27 12:43:43 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.