Data dictionary import and index partitions

Rafu

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?

SueHarper

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

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

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