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

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

Remke,

I am making a change in DDL::Oracle v1.02 to address this problem.  I
decided to omit the PARALLEL clause for 7.3 instances, because Oracle
does not supply the info needed in its normal dictionary views.  I could
have gone against the SYS.IND$ table, but I decided against this since
some [many?] users would not have access to this table.  I did not want
to use the parallelism of the table in the CREATE INDEX clause, since I
have no way to know if this is accurate.

I hope this will fix your problem.  I guess that means I hope that you
are not using a PARALLEL clause in your indexes.  Let me know if you
disagree.

Cheers,

Richard

--- Richard Sutherland <rvs...@ya...> wrote:
> 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/
> 
> _______________________________________________
> 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/