• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

HowTos | Basics | Concepts

  • Solaris
    • Solaris 11
    • SVM
    • ZFS
    • Zones
    • LDOMs
    • Hardware
  • Linux
    • CentOS/RHEL 7
    • RHCSA notes
    • SuSE Linux Enterprise
    • Linux Services
  • VCS
    • VxVM
  • Interview Questions
  • oracle
    • ASM
    • mysql
    • RAC
    • oracle 12c
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Hadoop
    • Hortonworks HDP
      • HDPCA
    • Cloudera
      • CCA 131

synonyms

Beginners guide to oracle synonyms

By admin

Synonyms as the word literally means, are aliases for referencing the database objects. By default, when you look for an object in the database, it tries to search it in your own schema. So, if you are user user01 and you try to query an object emp from scott's schema, oracle will return an error : sql> select * from emp select * from emp * ERROR at line 1: ORA-00942: table or view does not exist Why do we need synonyms? 1. Synonyms make the referencing of objects … [Read more...] about Beginners guide to oracle synonyms

Filed Under: oracle Tagged With: synonyms

Primary Sidebar

Recent Posts

  • Understanding “docker stats” Command Output
  • ‘docker images’ command error – “Permission Denied”
  • Docker Basics – Expose ports, port binding and docker link
  • How to split BCV and open oracle ASM database
  • How to change the interface name in CentOS/RHEL 8 using prefixdevname
  • Archives
  • Contact Us
  • Copyright

© 2019 · The Geek Diary