DBA_DATA_FILES inconsistency?

From: Rich <richa03_at_gmail.com>
Date: Fri, 15 Feb 2013 08:23:54 -0800
Message-ID: <CALgGkeB+0YXvxHWiGB1e9ftBfqzeHpm27QFGv4HZ2WBFastuRw_at_mail.gmail.com>

Hi List,
This is Oracle EE 10.2.0.5 on Solaris 5.10.

From SQL:
select FILE_NAME, FILE_ID, TABLESPACE_NAME, BLOCKS, STATUS, AUTOEXTENSIBLE, MAXBLOCKS, INCREMENT_BY, USER_BLOCKS, ONLINE_STATUS from dba_data_files where tablespace_name like 'HUB%';

I see the following:

FILE_NAME                              FILE_ID TABLESPACE_NAME       BLOCKS

STATUS AUT MAXBLOCKS INCREMENT_BY USER_BLOCKS ONLINE_

----------------------------------- ---------- --------------- ------------
--------- --- ------------ ------------ ------------ -------


/u01/insta/data/hubaaaa_03.dbf              17 HUBAAAA            3,840,000

AVAILABLE YES    3,840,000          128    3,839,984 ONLINE


/u01/insta/data/hubaaaa_02.dbf              16 HUBAAAA            3,840,000

AVAILABLE YES    3,840,000          128    3,839,984 ONLINE


/u01/insta/data/hubaaaa_01.dbf              10 HUBAAAA            3,840,000

AVAILABLE YES    2,560,000         1280    3,839,984 ONLINE


/u01/insta/data/hubaaaaindx_01.dbf           2 HUBAAAAINDX        1,190,400

AVAILABLE YES    2,560,000         1280    1,190,392 ONLINE

Am I missing something?

Shouldn't MAXBLOCKS be larger than BLOCKS (and USERBLOCKS) for FILE_NAME
/u01/insta/data/hubaaaa_01.dbf (FILE_ID 10)?

Anyone seen anything like this?

Thanks,

Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 15 2013 - 17:23:54 CET