Oracle 10G !!
C'est surtout ca qu'il faut faire avant autre chose :
ALTER TABLE Long_tab MODIFY ( long_col CLOB );
parce que LONG selon la doc officielle
1 2 3 4 5 6 7 8
|
LONG Datatype
Note:
Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility.
Oracle also recommends that you convert existing LONG columns to LOB columns. LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases |
Partager