Home » Other » Client Tools » Synonym for TYPE(URGENT)
Synonym for TYPE(URGENT) [message #38585] Mon, 29 April 2002 07:40 Go to next message
ranjan
Messages: 20
Registered: August 1999
Junior Member
Hi
Is is possible to create synonym for a oracle type.
If not then can you suggest how to use from a schema types created in different schema...

Ranjan
Re: Synonym for TYPE(URGENT) [message #38642 is a reply to message #38585] Thu, 02 May 2002 19:26 Go to previous messageGo to next message
Yogita
Messages: 8
Registered: April 2002
Junior Member
Try this

CREATE SYNONYM synonymname FOR schema.type;

CREATE SYNONYM offices FOR hr.locations;

-Yogita
Re: Synonym for TYPE(URGENT) [message #38649 is a reply to message #38585] Fri, 03 May 2002 05:02 Go to previous messageGo to next message
ranjan
Messages: 20
Registered: August 1999
Junior Member
Ya.... you can create synonym like that, but this does not work....
Re: Synonym for TYPE(URGENT) [message #38654 is a reply to message #38585] Fri, 03 May 2002 07:41 Go to previous message
Yogita
Messages: 8
Registered: April 2002
Junior Member
Check the privilege.

To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege.

To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system privilege.

To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM system privilege.
Previous Topic: EMail from Oracle
Next Topic: converting from Informix 4GL to PL/SQL
Goto Forum:
  


Current Time: Fri Mar 29 09:18:47 CDT 2024