Home » SQL & PL/SQL » SQL & PL/SQL » Creating Synonyms (Merged)
Creating Synonyms (Merged) [message #389504] Mon, 02 March 2009 06:32 Go to next message
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 Go to previous messageGo to next message
pablolee
Messages: 2836
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 Go to previous messageGo to next message
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 Go to previous message
cookiemonster
Messages: 12422
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?

Previous Topic: Insert into confusion
Next Topic: ptocedure restore
Goto Forum:
  


Current Time: Sat Dec 10 05:01:40 CST 2016

Total time taken to generate the page: 0.12052 seconds