Home » SQL & PL/SQL » Client Tools » Drop and recreate the synonym (Unix)
Drop and recreate the synonym [message #392081] Mon, 16 March 2009 05:36 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I have created 1 shell script. Now I want to created one synonym for one table. But It needs to be created every day.
Can any one please how add the synonym statement for drop and recreating every day.

Thank you
Re: Drop and recreate the synonym [message #392086 is a reply to message #392081] Mon, 16 March 2009 05:42 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
./fa/1620/0/
Re: Drop and recreate the synonym [message #392088 is a reply to message #392086] Mon, 16 March 2009 05:45 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

I have added the following in the script
DROP SYNONYM SYN
Create synonym SYN for EMP;


But getting synonym not created message.

Thank you
Re: Drop and recreate the synonym [message #392089 is a reply to message #392081] Mon, 16 March 2009 05:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
user71408 wrote on Mon, 16 March 2009 11:36
Now I want to created one synonym for one table. But It needs to be created every day.

Why?
Re: Drop and recreate the synonym [message #392091 is a reply to message #392088] Mon, 16 March 2009 05:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
user71408 wrote on Mon, 16 March 2009 11:45
I have added the following in the script
DROP SYNONYM SYN
Create synonym SYN for EMP;


But getting synonym not created message.

Thank you

That is NOT a standard Oracle message. Post the real message.
Re: Drop and recreate the synonym [message #392098 is a reply to message #392081] Mon, 16 March 2009 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why is this in "Client Tools" forum?

Regards
Michel
Re: Drop and recreate the synonym [message #392099 is a reply to message #392098] Mon, 16 March 2009 06:09 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Michel Cadot wrote on Mon, 16 March 2009 12:02
Why is this in "Client Tools" forum?

Regards
Michel



Because that's where user71408's "Which random forum to post this to"-generator told him to post it.
Previous Topic: PL/SQL Developer and OID
Next Topic: sql*plus under UNIX
Goto Forum:
  


Current Time: Mon Dec 05 05:11:50 CST 2016

Total time taken to generate the page: 0.09058 seconds