Add OLAP back into the database. @?/olap/admin/olap.sql SYSAUX TEMP Import OLAP Analytic Workspaces For each OLAP analytical workspace , run the following package procedures to import the workspace. exec dbms_aw.execute( 'aw create <owner>.<aw_name>' ); exec dbms_aw.execute( 'import all from eif file ''AW_MIGRATE/<schema>_<aw_name>.eif'' data dfns' ); exec dbms_aw.execute( 'update' ); commit; exec dbms_aw.execute( 'aw detach <owner>.<aw_name>' ); Drop the directory used to import the OLAP analytical workspace migration files. SQL> drop directory aw_migrate; Recompile invalid objects. SQL> SQL> select OWNER, AW_NAME ,PAGESPACES from dba_aws where owner != 'SYS' order by 1,2; AW_NAME PAGESPACES ------------------------------ ------------------------------ ---------- FPA FPAPJP 532 ZPB ZPBANNOT 8 ZPB ZPBCODE 480 ZPB ZPBDATA 8 Note further details can be found in MetaLink Note 352306.1 –
Add OLAP back into the database. @?/olap/admin/olap.sql SYSAUX TEMP Import OLAP Analytic Workspaces For each OLAP analytical workspace , run the following package procedures to import the workspace. exec dbms_aw.execute( 'aw create <owner>.<aw_name>' ); exec dbms_aw.execute( 'import all from eif file ''AW_MIGRATE/<schema>_<aw_name>.eif'' data dfns' ); exec dbms_aw.execute( 'update' ); commit; exec dbms_aw.execute( 'aw detach <owner>.<aw_name>' ); Drop the directory used to import the OLAP analytical workspace migration files. SQL> drop directory aw_migrate; Recompile invalid objects. SQL> SQL> select OWNER, AW_NAME ,PAGESPACES from dba_aws where owner != 'SYS' order by 1,2; AW_NAME PAGESPACES ------------------------------ ------------------------------ ---------- FPA FPAPJP 532 ZPB ZPBANNOT 8 ZPB ZPBCODE 480 ZPB ZPBDATA 8 Note – further details can be found in MetaLink Note 352306.1
RMAN-32-bit-to-64-bit-migration-using-TRANSPORT-DATABASE1.docx