Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Reducing a column's width
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 - 13:43:00 CST