Re: error in the output

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Fri, 28 Apr 2006 19:46:34 +0400
Message-ID: <e2tdcv$29if$1@hypnos.nordnet.ru>

"BS" <minimyme_at_yahoo.com> wrote in message news:1146238188.396992.152890_at_i39g2000cwa.googlegroups.com...
> Hi,
>
> I'm new to the oracle world and trying to find out the size of my
> oracle database. I ran the query as below and not getting the correct
> result back. Any pointer please??
>
> SVRMGR> select sum(BYTES) from DBA_DATA_FILES;
> SUM(BYTES)
> ----------
> 4.2001E+10
> 1 row selected.
>

Perfectly correct answer - in scientific notation. 4.2001E+10 = 42001000000. What's your Oracle version? svrmgrl was deprecated and obsoleted long ago.

-- 
   Vladimir M Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com

Received on Fri Apr 28 2006 - 10:46:34 CDT