HP-UX AAA Server A.07.01 Administrator's Guide

Table Spaces
The physical database storage units, data files, are associated with table spaces according
to the logical structure of the database. For example, table spaces may be created to
separate different categories of data. Table spaces are divided into smaller logical
divisions called segments, which are divided further into extents and data blocks. These
levels of data storage allow control over how the data files are allocated for physical
storage.
User Schema
A schema is a set of objects associated with a user. Schema objects include tables and
other data structures used by the database. These objects do not directly correspond
to data files stored on the server. Each object’s data is stored in one or more data files
within a table space. You can specify the space allocated for tables and a few other
objects.
Tables
Tables are the basic unit of storage in an Oracle database. Tables are defined by a name,
a set of columns, and other optional parameters. For each column, a column name,
data type, and width, precision, or scale must be specified. When a table is created, the
database allocates a segment in a table space for the table.
Using SQL statements, data is added and removed from the table by rows. Each row
represents one data record. Data can also be modified through SQL by removing
columns or changing the column value for a record.
Configuring the Oracle Database
Create the table that will store your users and then add their information to the table.
You can create a new database for your user table or add it to an existing database.
To Create the AUTH_NET_USERS Table
1. Start up an instance of the database where the users should be stored.
2. Start SQL*Plus at the Unix prompt and connect to the database with the SQLPLUS
command.
3. At the SQL prompt execute the create table SQL statement to add
AUTH_NET_USERS to the database. The statement must follow the predefined
structure described in Table 17-2.
To create the table quickly, you can run the create.sql command file by entering
START create.sql at the SQL prompt.
To Manage User Records in the AUTH_NET_USERS Table
• Add user records with the following SQL command:
The Oracle Database Structure 251