Re: ORA-02272 and Storage Constraints

"suntac" <suntacNOSPAMPLEASE_at_dds.nl> wrote in message news:rcp5fvsifob96tlcek4sfld8777tlcda9c_at_4ax.com...
> On Fri, 20 Jun 2003 12:40:31 +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?

What do you mean by 'storage constraint'? If you mean initial extent XXXX next extent YYYY etc then no these have no affect on what datatypes can be used.

NOT NULL on the other hand is a constraint.

SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jun 20 14:55:28 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Release 9.2.0.3.0 - Production
JServer Release 9.2.0.3.0 - Production

SQL> create table t1(col1 number not null);

Table created.

SQL> desc dba_cons_columns;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------

 OWNER                                     NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                           NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                                        VARCHAR2(4000)
 POSITION                                           NUMBER

SQL> select constraint_name,constraint_type   2 from dba_constraints
  3 where table_name='T1';

CONSTRAINT_NAME                C
------------------------------ -
SYS_C001250931                 C

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK