Re: Divisor is equal to zero

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

Then don't divide by zero.

The issue is obviously df.totalspace. As you give no indication of your Oracle version number or how it obtains a value no further help is possible.

If this is not enough to point you in the right direction ... please repost with enough information for someone to help you.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group