Databases Reference
In-Depth Information
's subsequent sessions, the session will be disconnected if the
session remains idle for 15 minutes.
For
SCRAWFORD
Assigning Default Tablespaces and Quotas
When a user creates some type of object—a table, an index, a sequence, or
another object—that object uses space in one of the database's tablespaces. In
addition, a user may need temporary space for sorting and other operations.
Each user has a default tablespace for permanent objects and a default tablespace
for temporary objects, although a user may explicitly create objects in a different
tablespace if the user has the proper permissions.
If a default permanent tablespace is not specified when the user account is cre-
ated, or a database-wide default permanent tablespace is not specified when the
database is created, the
SYSTEM
tablespace is used. It is generally not a good idea
to leave
tablespace contains
all of the data dictionary objects, there is a high level of contention in the
SYSTEM
as the default tablespace. Since the
SYSTEM
SYSTEM
tablespace already, so any new user objects in the
SYSTEM
tablespace might have
a negative impact on overall system performance.
Janice, the DBA, remedies this situation with the new user account and
changes the default tablespace:
alter user scrawford default tablespace users;
User altered.
Janice double-checks her work by querying the
DBA_USERS
data dictionary view:
select username, default_tablespace,
temporary_tablespace from dba_users
where username = 'SCRAWFORD';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------ -------------------- --------------------
SCRAWFORD USERS TEMP
1 row selected.
Janice makes a mental note to use the GUI-based Oracle Enterprise Manager
(OEM) tool or the web-based EM Database Control interface next time. The
OEM tool's Create User facility, shown below, is not only easier to use, but it
also automatically specifies the
USERS
tablespace as the default tablespace for
new users, among other defaults.
