Database Objects That Store Data

The Oracle database has a variety of important objects. These objects do many things. They are used to hold data, to locate data items efficiently, to combine data, and to make the database user-friendly. The remainder of the chapter will describe the various database objects that are used to store and locate data. A database administrator (DBA), rather than the data administrator, generally performs most of the tasks and commands that are discussed in this section. On rare occasions, a DA may perform some of the tasks, depending on the shop. However, whether you perform the database tasks, it is very important for the successful data administrator or business analyst to understand the basic mechanics and objects ...

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.