Category: >> Oracle PL/SQL >> TABLESPACE: SYSAUX Tablespace Bookmark and Share

<< lastnext >>

Snippet Name: TABLESPACE: SYSAUX Tablespace

Description: The SYSAUX tablespace is an auxiliary tablespace to the SYSTEM tablespace. Many database components use the SYSAUX tablespace as their default location to store data. The SYSAUX tablespace is always created during database creation or database upgrade.

The SYSAUX tablespace provides storage of non-sys-related tables and indexes that traditionally were placed in the SYSTEM tablespace.

The SYSAUX tablespace provides a centralized location for database metadata that does not reside in the SYSTEM tablespace. It reduces the number of tablespaces created by default, both in the seed database and in user-defined databases.

During normal database operation, Oracle Database does not allow the SYSAUX tablespace to be dropped or renamed. Transportable tablespaces for SYSAUX is not supported.

Also see:
» TABLESPACE: Show contiguous space
» TABLESPACE: Tablespace management
» TABLESPACE: List tablespaces, fil...
» TABLESPACE: Dropping Tablespaces
» TABLESPACE: Alter Permanent Tables...
» TABLESPACE: Transportable tablespa...
» TABLESPACE: Tempfile operations
» TABLESPACE: Create temp tablespace
» TABLESPACE: Change UNDO tablespace
» TABLESPACE: Undo Tablespace
» TABLESPACE: Set default tablespace...
» TABLESPACE: Oracle Managed Auto-ex...
» TABLESPACE: Permanent Tablespace U...
» TABLESPACE: Using Raw Devices
» TABLESPACE: permanent tablespace

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 12th, 2009

SELECT tablespace_name
FROM dba_tablespaces;
DATAFILE '/test/oradata/sysaux01.dbf' SIZE 700M
-- Moving SYSAUX contents
column occupant_name format a15
column occupant_desc format a30
column schema_name format a10
SELECT schema_name,occupant_name,occupant_desc,space_usage_kbytes
FROM v$sysaux_occupants;
-- You can move components tbs other than SYSAUX; first 
-- you need to know which component move is applicable or not.
column move_procedure format a25
column move_procedure_desc format a40
SELECT move_procedure,move_procedure_desc FROM v$sysaux_occupants;
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 6