Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Increase in column width
Message
De
05/07/2000 03:07:00
 
 
À
05/07/2000 00:05:17
Les Chandra
Mastersoft Pty Ltd
Melbourne, Australie
Information générale
Forum:
Oracle
Catégorie:
Problèmes
Divers
Thread ID:
00387707
Message ID:
00388236
Vues:
13
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform