Where Are the master, msdb, and tempdb Databases?
The SQL Server master, msdb, and tempdb databases do not exist in the Oracle world. In Oracle, other areas keep the system information, provide a way to schedule jobs, and maintain a temporary space for sorting and temporary tables.
System-level Information
For SQL Server databases and logins, the master database has the details. the master database contains the system information and server configurations. So, where is the master database information in Oracle?
In Oracle, the system-level information for the database instance is in the data dictionary, which is stored in the SYSTEM tablespace under the SYS schema. You can query views to retrieve this information about the database and objects ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
