CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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');
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [200 users online]    © 2010 psoug.org