Database Administration (MOSC)

MOSC Banner

Negative value in table

edited Apr 11, 2012 5:52AM in Database Administration (MOSC) 6 commentsAnswered
Hi all,

   Db version 9.2.0.4 32 bit on Linux.

   I imported db ago three days. Today, I use script to view size of objects such as:

SELECT owner, segment_name, segment_type, partition_name, ROUND(bytes/(1024*1024),2) SIZE_MB, tablespace_name
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE IN ('TABLE', 'INDEX', 'TABLE PARTITION', 'INDEX PARTITION',
'TABLE SUBPARTITION', 'INDEX SUBPARTITION')
AND OWNER ='XBANK'
AND tablespace_name = 'XBANKDATA'
ORDER BY bytes DESC;   

    But some tables has negative value at bytes (it's SIZE_MB) column.  

XBANK

XBANK_DATA_1TABLE-40464046.4XBANKDATA
   I don't know why it's negative value ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center