Database DataWarehousing (MOSC)

MOSC Banner

OLAP from 32 to 64 bit on windows

edited Nov 26, 2013 6:23AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi OLAP community,

I have migrated my E-business database from 32 to 64 bit on windows. In that process I have Migrated OLAP too .

I have followed
Document "Migrating OLAP From 32 Bits to 64 Bits (Doc ID 352306.1)"

When I exported on 32 bit the pagespaces are as below

SQL> select OWNER, AW_NAME ,PAGESPACES from dba_aws where owner != 'SYS' order by 1,2;

OWNER           AW_NAME         PAGESPACES
--------------- --------------- ----------
APPS            ODPCODE               1697
APPS            XWDEVKIT              1082
FPA             FPAPJP                 495
ZPB             ZPBCODE                458


Later when i imported into 64 bit the pagesizes are as below.

QL> select OWNER, AW_NAME ,PAGESPACES from dba_aws where owner != 'SYS' order by 1,2;

OWNER                          AW_NAME                        PAGESPACES

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center