Help Me Put Oracle Terminology into SQL Server Terminology

Help me put Oracle terminology into SQL Server terminology

Oracle/SQLServer:

• tablespace = doesn't exist
• database = doesn't exist
• instance = instance
• schema = database
• listener = doesn't exist
• service name = database name
• SID = database name

SQL statement joining Oracle and MS SQL Server

Yes- both Oracle and SQL Server support the linked server concept. That allows you to reference the other server using a 4 part name. For example:

select  *
from    LocalDb.Schema.Table
cross join
        OracleLinkedServer.RemoteDb.RemoteSchema.RemoteTable

Exploring data dictionary tables usage in Oracle?

You are right: developers (and wannabe DBAs come to that) should know the Data Dictionary, rather than relying on an IDE. A good Oracle practitioner should be able to survive with just a text editor and SQL*Plus.

There are too many views to understand them all. You just need to know that they are all covered in the documentation. Find out more.

---

Related Topics