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: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 20 Sep 2006 19:45:43 +0200
Message-ID: <45117e47$0$27249$636a55ce@news.free.fr> 






"muddu" <mudassar.dba_at_gmail.com> a écrit dans le message de news: 1158773314.686153.217120_at_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.

|




And what don't you understand in the error message?
And how can you expect a help giving us only 1 line of your query?



Regards


Michel Cadot
Received on Wed Sep 20 2006 - 12:45:43 CDT












Original text of this message













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