Database Reference
In-Depth Information
Chapter 23 shows how to create roles of your own.
Note:
Future releases of Oracle may not include these roles. You can
create your own roles to serve these or any other purpose you need.
When a user creates a table, that user is the table's owner. A schema is
the collection of all the tables owned by one user. For example, you log in as
the user STANLEY and you create a table called TREASURE_CHEST and
a table called JEWELRY. These two tables are in the STANLEY schema.
Chapter 18 describes how to create your own tables. For now, how-
ever, you have some already existing tables with rows of data inside. Your
job is to learn how to retrieve that data using the programming language
called SQL.
Now let's dig a little more seriously into the physical architecture of Ora-
cle Database. In its most simplistic form, an Oracle Database installation
consists of buffers, processes, files, network communication, and configura-
tion, as shown in Figure 3.5.
Figure 3.5
An Oracle
Database
Installation.
