Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Increase in column width
Message
From
05/07/2000 03:07:00
 
 
To
05/07/2000 00:05:17
Les Chandra
Mastersoft Pty Ltd
Melbourne, Australia
General information
Forum:
Oracle
Category:
Troubleshooting
Miscellaneous
Thread ID:
00387707
Message ID:
00388236
Views:
14
This is correct:
But the question was about increasing column length...

SQL> desc images
Name Null? Type
----------------------------------------------------- -------- --------------------
IMAGE LONG RAW
DB VARCHAR2(100)
FIELD VARCHAR2(10)
IMGKEY NOT NULL NUMBER(20)
MAINKEY VARCHAR2(125)

SQL> alter table images modify db varchar2(80);
alter table images modify db varchar2(80)
*
ERROR at line 1:
ORA-01441: column to be modified must be empty to decrease column length

SQL> alter table images modify db varchar(120);

Table altered.

SQL> desc images
Name Null? Type
----------------------------------------------------- -------- -----------------------------
IMAGE LONG RAW
DB VARCHAR2(120)
FIELD VARCHAR2(10)
IMGKEY NOT NULL NUMBER(20)
MAINKEY VARCHAR2(125)

Cheers!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform