Forum Stats

  • 3,782,592 Users
  • 2,254,669 Discussions
  • 7,880,131 Comments

Discussions

Data dictionary import and index partitions

Rafu
Rafu Member Posts: 186 Bronze Badge
Importing a Data Modeler model from data dictionary. Index partitions and tablespace definitions for partitioned indexes are not included in the generated model. Is this a missing feature or does anyone have quidelines howto include also those in import?

Answers

  • SueHarper
    SueHarper Member Posts: 2,579
    Rafu,

    There was work done on this area for patch 1. (Release in December last year) You should be able to import the local index definitions for your partitions. When testing this, I see the tablespaces associated with the partitioned table is not brought in. I'll log a bug on that.

    The latest build is on OTN. See the link to the patch.

    Sue
  • Rafu
    Rafu Member Posts: 186 Bronze Badge
    edited Feb 12, 2010 8:36AM
    Thank you for a quick reply. We are using the latest Data Modeler 2.0.0 Build 584.

    Here are three example local indexes. Their partitions are not captured from data dictionary import.

    drop table hpv purge;

    drop table hp purge;

    drop table v;

    create table hp(hp number(10) constraint hp_pk primary key using index local ) partition by hash(hp) partitions 2
    ;

    create table hpv(hp references hp, hpv number(4), constraint hpv_pk primary key (hpv,hp) using index local)
    partition by range(hpv) (partition p1 values less than (100), partition pmax values less than (maxvalue))
    ;

    create table v(v_id number constraint v_pk primary key, pv number not null)
    partition by range(pv) (partition p1 values less than (100), partition pmax values less than (maxvalue))

    create index v_pv_idx on v(pv) local;

    select * from user_ind_partitions where index_name in ('HPV_PK','HP_PK','V_PV_IDX');

    Edited by: Rafu on 12-Feb-2010 05:35

    Edited by: Rafu on 12-Feb-2010 05:35
  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,369 Employee
    Rafu,

    thanks for detailed example. There are two problems:
    - indexes on hash partitioned tables cannot be processed due bug in the code - this is also the reason for missing tablespace information for these indexes;
    - indexes created as result of such construct "primary key using index local " are not processed properly

    I logged bug for that.
    No problem with index on table v in your example - create index v_pv_idx on v(pv) local;

    Thanks,
    Philip
    Philip Stoyanov-Oracle
This discussion has been closed.