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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
