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.

Comments

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

    ReplyDelete
    Replies
    1. How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Now

      >>>>> Download Full

      How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download LINK

      >>>>> Download Now

      How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Full

      >>>>> Download LINK an

      Delete
  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

    ReplyDelete
  3. How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Now

    >>>>> Download Full

    How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download LINK

    >>>>> Download Now

    How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Full

    >>>>> Download LINK Cy

    ReplyDelete
  4. Thanks a lot, you made it really easy to understand I have bookmarked this page for my future reference. Do share more updates.
    Java Training in Chennai
    Java Training in Bangalore

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

How to Create Packages in Oracle Database using TOAD for Oracle

How to create a Simple Scheduler Job in Oracle Database using Toad