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

[Richard S. <rvs...@ya...>]

Remke,

Thanks very much for the bug report.  The testing on Oracle 7.3 has, to
be honest, been very sparce, so I am relying on users to help me out.  I
have only just recently been able to do any testing at all on 7.3.

As it turns out, this feature IS supported beginning with Oracle8, so the
other versions are just fine.  I will include a fix for this problem in
the next release (1.02), which may be ready within the next week.

Thanks again.  I really appreciate it!

Richard Sutherland

--- Remke Rutgers <Rem...@br...> wrote:
> 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
> 
> _______________________________________________
> DDL-Oracle-users mailing list
> DDL...@li...
> http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users


=====
Richard Sutherland
rvs...@ya...

The software said it requires Windows 95 or better,
so I installed Linux.

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/