Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: real newbie question (i think)
Hi Rich
>am i better off creating a new column in the existing
>table of the type clob or blob? should i create a
>new table to store this data?
This depends on what kind of queries hit this table. If most of your queries hit columns other than the lob then you are justified in creating new table for the lob so you have a 1-to-1 relationship between your original and lob table. obviously in order to tie your records of the lob table with the original table, include the pk of ur original table in the lob table and make it a FK pointing to the original table.
having said that, note that clob/blob is inline storage for data less than 250K (or some thing). Beyond that # the data will get stored outside in the lob tablespace you specified.
>and what would be my best way to keep these columns
>in sync...every time someone updated the long column
>i would want my new column updated to reflect the
>change
Does the foreign key creation stuff i wrote above answer this question. If not, please elaborate by what you mean by the "new column should reflect change"
Deepak
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: deepakthapliyal_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Wed Nov 14 2001 - 13:07:21 CST
![]() |
![]() |