Database Tuning (MOSC)

MOSC Banner

Migration to AIX

edited Jun 18, 2010 3:04AM in Database Tuning (MOSC) 6 commentsAnswered
Hello!

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    

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