Migration to AIX
I migrate Oracle Database 9.2.0.7 from Solaris SPARC 10 to AIX 5.3 with imp/export. When I gather stats on schema exec dbms_stats.gather_schema_stats('IBS',cascade=>true, Degree=>6), everything go as usual, but when gathering on a table:
create table Z#CLIENT
(
ID NUMBER,
CLASS_ID VARCHAR2(16),
C_NAME VARCHAR2(250),
C_INN VARCHAR2(12),
C_REGISTR_NUM NUMBER(9),
C_PRIVILEGES NUMBER not null,
C_DISPOSIT NUMBER not null,
C_I_NAME VARCHAR2(250),
C_CONTACTS NUMBER not null,
C_ADDRESSES NUMBER not null,
C_INSPECT NUMBER not null,
C_COUNTRY NUMBER,
C_NOTES VARCHAR2(2000),
C_ACC_BANK NUMBER not null,
C_INTERNAL_CODE