Hello,

I am planning to migrate DB data from ORACLE 11gR2 on AIX 6.1 to ORACLE 11gR2 on CentOS 6.9.

Many gurus told me using ASM and RMAN but my site is not using both of them.

By the different endian format, I think I need to use transportable tablespace using CONVERT command.

But, it has so many steps and I cannot try to do this with running production database.

So is there any another better way to migrate data to new DB?

I tried using expdp and impdp to migrate data, but it needs too many disk to keep export dump data and it takes little long time.

Also I faced ORACLE error like this during importing data,
==============================
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

----- PL/SQL Call Stack -----
object line object
handle number name
0x15c273550 20462 package body SYS.KUPW$WORKER
0x15c273550 9028 package body SYS.KUPW$WORKER
0x15c273550 16665 package body SYS.KUPW$WORKER
0x15c273550 3956 package body SYS.KUPW$WORKER
0x15c273550 9725 package body SYS.KUPW$WORKER
0x15c273550 1775 package body SYS.KUPW$WORKER
0x15eade240 2 anonymous block

ORA-39097: Data Pump job encountered unexpected error -1427
ORA-39065: unexpected master process exception in DISPATCH
ORA-01427: single-row subquery returns more than one row

Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at 01:05:34
=============================

I solved this problem by exporting and importing data and statistics information separately.

But it made me so confused and worring about another data missed.

Thank you in advance for your great support.

Have a good day!