| General |
|
Note: For moving the OLAP catalog |
| Source |
Unknown. Only reference in $ORACLE_HOME/rdbms/admin/oracle.sym |
| First Available |
10.2 |
| Dependencies |
| DBA_INDEXES |
DBA_TABLES |
DBA_TABLESPACES |
|
Related Query |
set linesize 121
col occupant_desc format a55
col move_procedure format a50
SELECT occupant_desc, move_procedure
FROM gv$sysaux_occupants
ORDER BY 1;
col occupant_desc format a15
SELECT occupant_desc, move_procedure
FROM gv$sysaux_occupants
WHERE move_procedure LIKE '%AMD%';
OCCUPANT_DESC MOVE_PROCEDURE
--------------- --------------------------
OLAP Catalog DBMS_AMD.Move_OLAP_Catalog |
| |
| MOVE_OLAP_CATALOG |
| Moves the OLAP data
dictionary tables to a tablespace other than SYSAUX. |
dbms_amd.move_olap_catalog(dest_tbs IN
VARCHAR2); |
| exec dbms_amd.move_olap_catalog('USERS'); |
