Re: Renaming columns?
From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Sat, 20 Aug 94 22:45:00 -0300
Message-ID: <2aa.724.846%mpcbbs_at_ibase.org.br>
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Sun Aug 21 1994 - 03:45:00 CEST
Date: Sat, 20 Aug 94 22:45:00 -0300
Message-ID: <2aa.724.846%mpcbbs_at_ibase.org.br>
On 19 Aug 94 02:35pm, Heikki Rissanen wrote to ALL:
HR> Newsgroup: comp.databases.oracle
HR> Organization: Oracle User Group Finland
HR> Howard Hartsfield (howardh_at_freenet3.scri.fsu.edu) wrote: HR> : Is there a way to rename a column in Oracle?
HR> No that I know. You can create a new table from the old one. HR> If you cannot or don't want to do that, create new column,move HR> data,empty old one and change it to char(1).
Only for small tables. Imagine tables with 1 GByte! It's impossible!
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |
|---------------------------------------------------------------------------|
| Softex 2000 member | Brazil, Sao Paulo state, Campinas city |
=============================================================================
- Evaluation copy of Silver Xpress. Day # 57
--- via Silver Xpress V4.01P [NR]
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Sun Aug 21 1994 - 03:45:00 CEST