Re: real newbie question (i think)

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Wed, 14 Nov 2001 11:07:21 -0800
Message-ID: <F001.003C4E0D.20011114104209@fatcity.com>

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

• Rich Davidson <RDavidson_at_dynamicsoft.com> wrote:
  > hey all,
  >
  > i'm in your typical situation of "we don't need a
  > dba...oracle is an app so
  > the bizapps guy can handle it"....right...now to
  > reality. there is a column
  > in our database (oracle is the back end of our crm
  > package) that is defined
  > as a long and they want to do keyword searches on
  > it. i've found out that
  > you can't use type long in a where clause.
  >
  > i guess i have a few questions and i'm going to
  > assume the answers (if
  > anyone answers...please oh please do) will be a
  > matter of opinion. 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? 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.
  >
  > right now we're on 8.0.6/win 2k...but could upgrade
  > to 8.1.7 (means
  > upgrading our crm package too) if it makes this
  > process easier.
  >
  > thanks in advance for the help and not being a dba i
  > hope what i wrote makes
  > sense!
  > *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:
  > rich davidson
  > dynamicsoft Inc.
  > east hanover, nj
  >
  > rdavidson_at_dynamicsoft.com
  > t. +1-973-503-6169
  > f. +1-973-952-5050
  >
  >
  

  ---

Do You Yahoo!?
Find the one for you at Yahoo! Personals http://personals.yahoo.com

-- 
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