$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle DBMS_AMD Version 11.1  
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');
    EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>