O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required