Re: Appending columns

In article <2kjfj5INNnsa_at_skink.cis.ohio-state.edu>, skiba_at_cis.ohio-state.edu (david j skiba) wrote:

> I have a table created in an oracle 6 database. Is there an easy way
> to append a new column to the table after data is already in it?

As long as you don't want the column to be NOT NULL (which is obviously impossible) there is an easy way SQL> ALTER TABLE your_table ADD your_new_column_name your_column_definition (check the alter table command, also if you wish to alter a column definition (expand a column or remove the NOT NULL constraint)  

>
> The only way I could think of was to export, delete table, recreate
> new table, import. I am not sure if this will work and was hoping
> for a much easier way...
>
> thanks
You're welcome

> dave skiba
 

-- 
Leo Mannhart
Planning Office
University of Zurich                              phone: ++41 1 257 23 34
Kuenstlergasse 15                                   fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland                       eMail:
mannhart_at_zuv.unizh.ch