How Change Column Name?

Hi,

I have a table that has a column named 'filler' that was not used and I want to use it now and rename it to 'seq_no'. What is the best way to do this?

I do not know how to get the data back in if say I export the table. If I do then the export file has a create stmt, which I can get by with IGNORE=Y on import, but in the INSERT stmt it names all the columns
and therefore will not import.

'filler' and 'seq_no' will be the same size so it is really just a col.
name change. Is there a way to dump table data to a stream like file, one row of comma separated after another so I can reinput it with sql-loader
or what?

The col. has no foreign key ties or anything.

Thanks.

stantow_at_ibm.net Received on Thu Dec 04 1997 - 00:00:00 CST