Re: Reducing a column's width

You could try to exp the table

 truncate the table

 alter the table

 imp the table with the option ' Ignore create error due to object existence ' = yes

Jean Boulé
jboule_at_mediom.qc.ca

newbie22_at_my-deja.com a écrit dans le message <81c6c3$epq$1_at_nnrp1.deja.com>... HI all,

How can I change a column's width,
where the column is not currently empty?

You can't do it with ALTER TABLE,
because the field is not empty.

So far, I don't think that you could
export the data (with the unix utility exp) because you export the entire table structure, and all the associated data.

You could do it by creating another table: Create table new_table as
(Select substr(fieldname ) field_name, etc.
)

However, we don't have enough space left to do this.

Any suggestions?

Newbie

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 22 1999 - 14:03:22 CST