| Drop and recreate the synonym [message #392081] |
Mon, 16 March 2009 05:36  |
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 #392091 is a reply to message #392088] |
Mon, 16 March 2009 05:47  |
Frank
Messages: 7901
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 #392099 is a reply to message #392098] |
Mon, 16 March 2009 06:09 |
ThomasG
Messages: 3211
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
