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.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 12th, 2009
FROM dba_tablespaces;CREATE TABLESPACE sysaux
DATAFILE '/test/oradata/sysaux01.dbf' SIZE 700M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;-- Moving SYSAUX contents
column occupant_name format a15
column occupant_desc format a30
column schema_name format a10
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;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.