Re: ORA-0227 and storage Constraint

Making a column NOT NULL is the same thing as adding a CHECK constriant to that column. That is why you got the error. You can't have a CHECK constraint on a LONG column. Storage clauses do not stop you from creating a table with specific columns.

HTH,
Brian

suntac wrote:
>
> On Fri, 20 Jun 2003 12:39:57 +0200, suntac <suntacNOSPAMPLEASE_at_dds.nl>
> wrote:
>
> >I am trying to create a new table containing a LONG column. I get a
> >ORA-02272 (constrained column cannot be of LONG datatype) There is No
> >constrain on this column but there is a constrain on Storage.
> >
> >A Constraints Storage can this prevent me of creating a LONG column?
> >Where can I edit a Storage Constraints?
> >
> >Thanks a lot already.
> >
> >Regards,
> >Johan
>
> Found the solution already with some playing with some options. It
> must be able to be NULL if you tell the database it is inpossible to
> be NULL you get the ORA-02272.
>
> On the other hand I wonder, is it possible that storage constraints
> prevent you from creating a column of a specific datatype?
>
> Regards,
> Johan.

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"