| General Information |
| Note: For moving the OLAP catalog |
| Source |
Unknown. Only reference in $ORACLE_HOME/olap/admin/cmw2mov.pls |
| First Available |
10.2 |
| Dependencies |
| DBA_INDEXES |
DBA_TABLES |
DBA_TABLESPACES |
DBMS_ASSERT |
|
| Related Queries |
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 |
| Security Model |
Owned by SYS not privileges granted |
| |
| 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'); |
