A design question
Date: Fri, 20 Feb 2004 16:00:34 GMT
Message-ID: <CaqZb.3866$xz2.34305279_at_news-text.cableinet.net>
This question is not strictly Oracle only but as I'm using Oracle 8i I couldn't think of a better place to post it!
Anyway my problem/qustion is that I have a record that has in access of 200 fields - all the fields relate entirely to a record. Virtually all fields are optional e.g NULL.
Just wondering is there is a better way to manage them as the users want an audit log of changes so before every update the whole record has to written to the audit table - this can happen if theres only one change. I know I could work out a way to just write changed fields values but time is so tight I have to write the entire record for now.
I could move blocks of fields in to other related tables but there will ALWAYS be a one to one relationship so it seems wrong to me anyway to separate them.
Any suggestions/ideas?
thanks
harry Received on Fri Feb 20 2004 - 17:00:34 CET