[DDL-Oracle-users] dba_indexes.instances and dba_indexes.degree do not exist

[Remke R. <Rem...@br...>]

Hello listmembers (just Richard?),

I just discovered your library today and it looks very promising.
I think however I discovered a bug.
I am using Oracle 7.3.3.0 on Solaris and ActiveState Perl.
Note that I am in no way an experienced perl programmer, I can copy paste
and modify, but hardly program in perl from scratch. I am a reasonably
experienced Oracle user, but no DBA.

When using 
my $obj = DDL::Oracle->new(
                            type  => 'table family',
                            list  => $list,
                          );
to create a script that includes indexes, constraints etc, I get an error
message from Oracle.pm line 1252. (version 1.01)
i.instances does not exist. (i is an alias for dba_indexes)
Four modifications fixed the problem:
1085              LTRIM(t.degree)
1086            , LTRIM(t.instances)
1124            , ${view}_segments  s,	${view}_tables t
1127              AND s.segment_name = i.index_name    AND s.segment_name =
t.table_name

Of course the same modifications are necessary for other versions of Oracle.

A different view? Let me know.

Remke
____________________________________________
Remke Rutgers - Rem...@br...
Technisch Consultant

Bright Alley - Media Park                              
Sumatralaan 45 / Postbus 10            
1200 JB Hilversum
web  www.brightalley.com
tel +31 35 6774000 / fax +31 35 6774355