Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Divisor is equal to zero

Divisor is equal to zero

From: muddu <mudassar.dba_at_gmail.com>
Date: 20 Sep 2006 10:28:34 -0700
Message-ID: <1158773314.686153.217120@i42g2000cwa.googlegroups.com> 





Hello,



I am running a sql script to determine how much % the tablespaces are
occupying.


But I am getting this error:



ERROR at line 3:


ORA-01476: divisor is equal to zero



line 3: round(100 * (us.usedspace / df.totalspace)) per.



Thanks.
Received on Wed Sep 20 2006 - 12:28:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US