How to Create Synonyms in Oracle using TOAD for Oracle

A synonym is a database object that provides a better name to refer to objects. You can use synonyms to shorten lengthy names or to ease the reference to an object owned by another user. You can create synonyms for a table, view, sequence, procedure and other objects.
In this post I will show you how to create Synonyms in Oracle Database using TOAD for Oracle.

Connect to Oracle Database using TOAD. Click on Database menu and open Schema Browser

On the Schema Browser open Synonyms Tab and click on New button to create synonym

Create Synonym window will open, select the object type (Here I am creating synonym by using Table object). Find your required Object and move it from Available Objects. Give the synonym name (Here I am using EM as synonym name). If you want to make synonym, private uncheck the Make Public check box. Click OK to create Synonym.

Now your newly created EM synonym and its structure is showing under the Synonym Tab in Schema Browser.


  1. postingan yang bagus tentang How to Create Synonyms in Oracle using TOAD for Oracle

  2. too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, Synonyms In Oracle


  3. We are providing their services for different relocation needs such as home shifting, commercial shifting, local household goods shifting.
    Relocation Services in Hyderabad
    Moving Organization in Bangalore


  4. We are associated with top rated, quality, insured, reliable and experienced movers and packers companies.
    Shifting and Moving in Mumbai
    Household Moving in Pune


  5. Trusted companies that are serving for years and are providing high quality shifting experience to their clients.
    Packing and Moving in Delhi
    Reliable Packing Services in Gurgaon


Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle

Create Tables in Oracle Database using TOAD