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 -> Re: Divisor is equal to zero

Re: Divisor is equal to zero

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Sep 2006 20:24:15 +0200
Message-ID: <6p13h2tf5gshdum40j62a6tomudpp0q27q@4ax.com>


On 20 Sep 2006 10:28:34 -0700, "muddu" <mudassar.dba_at_gmail.com> wrote:

>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.

The cause is obvious. Please go back to school and ask your money back.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 20 2006 - 13:24:15 CDT

Original text of this message

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