| Creating Synonyms (Merged) [message #389504] |
Mon, 02 March 2009 06:32  |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi All,
I want to create a synonym "X" should get created every run of FGD(schema) loading or should it be created only once at installation.
Synonym must be re-created every days as the FGD schemas is dropped every days.
Please let me know how to do this.
I knwo about synonym is :
Create or replace
Public/Private synoym <synonym_name>
for <Table_Name>
But according to the requirement I didn't get clearly. So can you any one please clarify my doubt and let me know the way of creation.
Thank you.
|
|
|
|
| Re: creating Synonym [message #389512 is a reply to message #389504] |
Mon, 02 March 2009 06:51  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
OK, I'll bite while I'm waiting on a resultset returning.
Not sure exactly what problem you are having. You say that you know the syntax (which you have confirmed by posting it) but...
| Quote: | But according to the requirement I didn't get clearly
|
it appears that you are not clear on the requirement. What requirement? What exactly is the problem that you are having.
Have you tried creating the Synonym and can't? If not, Why not. Are you unsure as to what your customer's requirements are? If this is the case, how are we to help?
Please try to be a clear as you can.
|
|
|
|
| Create synonym FIELDS [message #389716 is a reply to message #389504] |
Tue, 03 March 2009 06:35 |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Create a synonym FIELDS in BSC schemas that point to SGPT.B_TL_FIELDS . Please let me know how to do thistask and
A new interface need to be create between BSC and MSC (BSC need the right to read B_TLL_FIELDS in MSC database) !!
Please give me idea for these tasks.
Thank you.
|
|
|
|
| Re: Creating Synonyms (Merged) [message #389736 is a reply to message #389504] |
Tue, 03 March 2009 07:28 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Please learn to explain yourself clearly.
What is BSC?
What is MSC?
What relation do these have to SGPT?
What relation do these have to FGD?
| Quote: |
it appears that you are not clear on the requirement. What requirement? What exactly is the problem that you are having.
Have you tried creating the Synonym and can't? If not, Why not. Are you unsure as to what your customer's requirements are? If this is the case, how are we to help?
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
