Quick Search:
 
 Oracle PL/SQL: TABLESPACE: SYSAUX tablespace Jump to:  
Category: >> Oracle PL/SQL >> TABLESPACE: SYSAUX tablespace  

<< lastnext >>

Snippet Name: TABLESPACE: SYSAUX tablespace

Description: List schemas in the SYSAUX tablespace.

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

Comment: (none)

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

 
col occupant_name format a25
col schema_name format a20
col move_procedure format a30
col move_procedure_desc format a40
SET linesize 131
 
SELECT occupant_name, 
schema_name, 
move_procedure, 
move_procedure_desc
FROM v_$sysaux_occupants;
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org