Q

Functionality of SYSTEM tablespace in Oracle

What is the functionality of the SYSTEM tablespace?

What is the functionality of the SYSTEM tablespace?
All major database systems include something called a Data Dictionary. A Data Dictionary describes the contents of the database. Which tables do I own? What columns are in those tables? Do I have permissions to view other tables? Do these tables have indexes? Where are these tables physically located? What code runs when I execute a stored procedure? The Data Dictionary contains the answer to all of these questions and more. Before any application can access the data in the database, the Data Dictionary is consulted to manage the transaction. Basically, the Data Dictionary is the master guide to everything in the database. The primary purpose of the SYSTEM tablespace is to hold the Data Dictionary. The Data Dictionary is composed of all tables owned by the SYS user. You can query the Data Dictionary through many views which are documented in the Oracle Reference Guide for your version.
This was first published in July 2007

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close