Xref: alice comp.databases.oracle.misc:35549
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: celia9268@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: Renaming a column in Oracle 7.3.3
Date: Wed, 07 Jul 1999 16:56:32 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 33
Message-ID: <7m00rn$i3v$1@nnrp1.deja.com>
References: <19990702001611.23766.00005452@ng-cf1.aol.com> <7lv7re$8ha$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Jul 07 16:56:32 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT)
X-Http-Proxy: 1.1 x22.deja.com:80 (Squid/1.1.22) for client 205.150.160.214

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@nnrp1.deja.com>,
  thaar_altaiey@my-deja.com wrote:
> no way.
> best regards
> thaar@hotmail.com
> In article
> <19990702001611.23766.00005452@ng-cf1.aol.com>,
>   vblanton@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@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.