Re: Renaming a column in Oracle 7.3.3

The only way you can do is exp/imp.
When you do imp, set indexfile=yourfile.sql, then you can edit yourfile, and run yourfile to create table. Remember if there are referential constraints, don't take this way.

HTH
celia
In article <7lv7re$8ha$1_at_nnrp1.deja.com>,   thaar_altaiey_at_my-deja.com wrote:
> no way.
> best regards
> thaar_at_hotmail.com
> In article
> <19990702001611.23766.00005452_at_ng-cf1.aol.com>,
> vblanton_at_aol.com (VBlanton) wrote:
> > Is it possible to rename a column without
> dropping and recreating the entire
> > table?
> > Is there a way of using the ALTER statement for
> this purpose?
> > Any ideas?
> >
> > Thanks
> > vblanton_at_aol.com
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 07 1999 - 11:56:32 CDT