BYTES in DBA_DATA_FILES shows NULL

From: Gunawan Yuwono <gyuwono_at_yahoo.com>
Date: Tue, 29 Jul 2003 07:19:23 -0800
Message-ID: <F001.005C7A81.20030729071923@fatcity.com>

Hi all,

Can somebody explain how you can have NULL value for BYTES field in DBA_DATA_FILES? However, V$DATAFILE view shows the correct size under BYTES field.

Query the SYS.X$KTFBHC, ktfbhccval field is equal to 1 for the offending datafiles.

Tempting to bounce this production database later if that will fix the problem.

How this happened...
1) ran script to add datafiles to existing tablespace:

   ALTER tablespace DATA_HISTORY add
   datafile '/u09/bilp/data_history_05.dbf' SIZE 1966088K,    '/u06/bilp/data_history_06.dbf' SIZE 1966088K;

2) broke out of session
3) files were created on mount points /u09 and /u06
4) I saw that the files were created on UNIX, but Oracle still saw them a 0

bytes
5) I tried to resize the datafile's (received error - ORA-0600)

• alter database datafile '/u06/bilp/data_history_06.dbf' resize 100M 6) Took datafiles off-line 7) Tried to take them online, got a message that recovery is needed. Recovered datafiles 8) datafiles online, but still show 0 bytes 9) I was able to select and insert records into a table that uses this tablespace.

Any idea will be greatly appreciated.  

Thanks,
Gunawan Yuwono
Oracle DBA
Kansas City

---

Gunawan Yuwono
Oracle DBA
Kansas City, USA

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gunawan Yuwono
  INET: gyuwono_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 29 2003 - 10:19:23 CDT