Hi,
Using data pump utilities, I exported data from Oracle 11g R1 (11.1.0.7) on Windows XP 32-bit then tried importing it into Oracle 11g R1 (11.1.0.7) for Windows 2003 Server 64-bit. Following is what I got:
C:\oracle\oradb11g\olap\admin>impdp system/pss REMAP_TABLESPACE=HH07_DATA:
NBS_DATA DIRECTORY=dpdir DUMPFILE=ORA11G_02_14_2010.DMP LOGFILE=IMPORT.LOG SCHEM
AS=em8
Import: Release 11.1.0.7.0 - 64bit Production on Sunday, 14 February, 2010 13:48
:39
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** REMAP_TABLESPACE=HH07
_DATA:NBS_DATA DIRECTORY=dpdir DUMPFILE=ORA11G_02_14_2010.DMP LOGFILE=IMPORT.LOG
SCHEMAS=em8
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "EM8"."HH07_EXPENDITURE_DATA_VW" 1.662 MB 22263 rows
. . imported "EM8"."HH07_FAMILY_MEMBERS_VW" 106.2 KB 864 rows
. . imported "EM8"."HH07_APPLIANCES_VW" 32.31 KB 109 rows
. . imported "EM8"."HH07_BLDG_HOUSE_INFO_VW" 32.50 KB 109 rows
. . imported "EM8"."HH07_COVER_INFO_VW" 37.71 KB 109 rows
. . imported "EM8"."HH07_MEMBERS_ANNUAL_INCOME_VW" 55.05 KB 309 rows
. . imported "EM8"."HH07_PRODUCTIVE_ACTIVITIES_VW" 19.51 KB 107 rows
. . imported "EM8"."HH07_USERS_VW" 0 KB 0 rows
. . imported "EM8"."HH07_VISITS_SCHEDULE_VW" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-37162: OLAP error
XOQ-01151: OCI error:
ORA-24315: illegal attribute type
Failing sql is:
BEGIN
dbms_cube_exp.schema_info_imp_beg(1, '11.01.00.00.00');
dbms_cube_exp.schema_info_imp_loop(1, '11.01.00.00.00', '<?xml version="1.0" encoding="UTF-16"?>
<Metadata
Version="1.1"
CreateOnly="True">
</Metadata>');
dbms_cube_exp.schema_info_imp_end(1, '11.01.00.00.00');COMMIT; END;
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at 13:48:45