Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Two LONG RAW fields in one table?

Re: Two LONG RAW fields in one table?

From: Matthew Arrocha <marrocha_at_belllsouth.net>
Date: 1997/10/28
Message-ID: <01bce3a9$82965640$3b028ad1@marrocha>#1/1

Yes, according to the Oracle rul book you can have only 1 long/long raw per table in Oracle7, in Oracle8 you convert to LOBs and have multiples.

Matthew Arrocha
marrocha_at_bellsouth.net

Michael Jenc <jenc_at_cas_software.de> wrote in article <34477433.6FFF_at_cas_software.de>...
> Hi,
>
> have you ever tried to create a table that contains two
> fields of the LONG RAW datatype?
> I get the error message that this is not possible. For
> me this is very sad. I thought that Oracle would be a good
> choice for huge databases...
>
> OK, a solution would be to split that table into two and
> define a view that selects both. But in my application
> I would have to write lots of extra code to edit and to
> insert records into such a view.
>
> Are there any other soltions than the above?
>
> Bye and thanks in advance
> Michael
> --
> *********************************************************
> Michael Jenc
> CAS Software GmbH
> Karlsruhe, Germany
>
> Replace the '_' with '-' in E-mail address to contact me
>
  Received on Tue Oct 28 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US