<<Previous Next>>
Oracle -
Explain how to assign a Tablespace to a user in Oracle - June 27, 2009
at 11:00 AM
Explain how to assign a Tablespace to a
user in Oracle.
The following statement assigns already created tablespace
‘TABLESPACE_01’ as the tablespace group for user sh:
ALTER USER sh
TEMPORARY TABLESPACE
TABLESPACE_01;
Also read
A table space can be considered as a storage location where the
database objects are kept...........
Tablespaces, Database's schema objects..........
SYSTEM Tablespace, SYSAUX Tablespace, UNDO Tablespace, TEMP
Tablespace.........
The logical layer of the database consists of the following elements:............
|
