Database Reference
In-Depth Information
Figure 3.1
A Typical Oracle
Database 10g
Database Server.
later chapters) to loading data from an online application. The computer
that contains all of these elements is called the
database server
.
Note:
When you install Oracle Database on a Windows 2000, NT, or XP
Pro system, the installation creates the Oracle instance and a database for
you and sets up the software so that the Oracle instance starts up every time
you start up your computer. On UNIX and Linux platforms, it is possible
to automate Oracle instance and database startup, which is not always done
by the Oracle Installer. See your installation guide.
What goes into those datafiles? In a relational database of any kind, the
basic storage unit within the database is called a
. Just like a spread-
sheet, a table has rows and columns. Columns define what categories of
information the table can store, and each row contains values for each of
the categories for one record or item in the table.
A database is different from a spreadsheet in these ways:
table
A database stores more data
database can
store thousands of tables with millions of rows in each table.
. One Oracle Database 10
g
