Re: Oracle RAC and LOB columns

I think you're confusing the Index Cluster segment type with the Real Application Cluster server configuration (not surprisingly, given the similarity of the names!).

The doco is therefore saying that Index Clusters (probably Hash Clusters too, but I don't have that information to hand) cannot be created with LOB columns, not that a regular heap table can't use LOBs in a RAC environment.

Confirmation of this interpretation is contained in the Application Developer's guide
(http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88879/a dl08lo5.htm#121602)
where the following quote makes it clear what they are saying:

"LOBs are not allowed in clustered tables, whereas LONGs are allowed."

Notice the use of the phrase "clustered tables". They mean the "create cluster" command doesn't allow them, not that a 'create table' that happens to use a LOB will fail in a RAC setting. It won't.

Regards
HJR "Björn Qvarsell" <bq_at_symsoft.se> wrote in message news:7f9eee80.0204220100.59cb62d9_at_posting.google.com...
> I just stumbled on some information regarding limitations for the LOB
> data type (Oracle 9i SQL Reference). It said that a cluster cannot
> contain LOB columns. Is this true for a Real Application Cluster
> environment? Should one use the LONG data type instead although Oracle
> "strongly recommends" that you convert your LONG columns to LOB
> columns or do the same limitation apply for the LONG datatype as well?
>
> Anyone who has some more information on this?
>
> thanks
> .björn
Received on Mon Apr 22 2002 - 05:40:20 CDT