What's wrong ? All Neena did was give another answer to the original
question - she even said don't do it except in test.
-Original Message-
Sent: Wednesday, February 14, 2001 9:41 PM
To: Multiple recipients of list ORACLE-L
Boy, am I tired of people suggesting this kind of thi
I also fully agree with Suarabh.JL if you know way
how to rename a column in 8i.Pls. share the syntax
with us.It will be great help to all of us.
Regards
Bipin
--- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > i
think u can't rename a column. it's still under
> consideration.
> if u can, pls mentio
quot;black
magic" myself in my test database. I do not endorse it either.
Thanks.
- Kirti
> -Original Message-
> From: Steve Adams [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 3:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re
Hi Kirti,
Assuming that your post was not "tongue in cheek", while I don't endorse the
procedure, the Ixora web site has a note about a potential problem with doing
this and how to work around it at http://www.ixora.com.au/q+a/dd.htm#31_08_1999.
Please note the disclaimer there too.
@ Regards,
Been there, done it. It's dangerous. Don't ever do it.
I was lucky and was able to reverse the changes. I know
and Oracle instructor who was not so lucky and lost a database.
I've heard of other people doing this and it worked properly.
It's usually a bad idea to mess with the data dictiona
Oracle will absolutely not support your database if you ever reveal to them
that you've directly hacked the data dictionary. And with good reason.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Wednesd
Have you personally done this in your test database (and may be in your
production database)?
Are there any 'side effect' as to Oracle may not support any problems it may
create down the road?
Or this is a perfectly safe operation to 'just do it' ? If so, what type of
'risks' it might have?
I w
tiple
recipients of list ORACLE-L Subject: Re: Renaming a Column
In Oracle It's not possible to rename a column.You can instead
use alias for that column name in your queries. Or you have to
create a new table from existing one Drop existing table.And recreate a
table by
] [mailto:[EMAIL PROTECTED]]On
Behalf Of bipin sahani
Sent: Wednesday, February 14, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Renaming a Column
In Oracle
It's not possible to rename a column.You can instead
use alias for that column name in your queries.
Or you have to c
No , in 8i it is still impossible to rename a column.Only you can drop a
column.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 4:20 PM
> "Cale, Rick T (Richard)" wrote:
> >
> > 8i allows dropping a column or marking
ist ORACLE-L
I didn't find it any of my docs for 8.1.7 either. Is renaming a column
getting confused with dropping a column?
For renaming columns, one has to wait till 9i is a reality, I was told
- Kirti
> -Original Message-
> From: Joseph S. Testa [SMTP:[EMAIL PROT
I know someone asked how many of us would use the "backdoor methods" to rename
columns. I believe the answer is only the foolhardy & those with suicidal
tendencies. The only way to "rename" a column, without reverting to the view
thing, is to create a new table with the correct definition & then
Below are the steps and examples to rename a table:
1. create a view of the table which you want to rename its column
vantive> desc salgrade;
NameNull?
Type
-
"Cale, Rick T (Richard)" wrote:
>
> 8i allows dropping a column or marking them as unused. I do not think you
> can yet rename a
> column. Please provide an example.
>
> Thanks
> Rick
wel... you cluld always add the new column, populate it with the old
column's data, then drop the old colu
I didn't find it any of my docs for 8.1.7 either. Is renaming a column
getting confused with dropping a column?
For renaming columns, one has to wait till 9i is a reality, I was told
- Kirti
> -Original Message-
> From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]]
> S
ents of list ORACLE-L
> Subject: Re: Renaming a Column
>
> i think u can't rename a column. it's still under consideration.
> if u can, pls mention with some more specific syntax.
>
> it'll b helpful for all.
> saurabh
> - Original Message -
Hi All
I think I did send one out earlier. Don't bite.
You can't rename a column. The combatibility parameter issue I was thinking
of has to do with when you want to drop a column in 8i. That I know, has to
be greater or equal to 8.1.0 when you want to drop a column
Sorry again
Regards
JL
--
; From: Trassens, Christian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 3:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Renaming a Column
>
> Well, it isn't recommend it but you can update the field name of sys.col$
> table.
>
Ok i'll bite, i try to keep up with the new features and i'm looking at
8i(8.1.7) docs right now and i dont see it, would you like to elaborate?
you can rename a table, rename a partition but NOT rename a column, this
has been on the wish-list for many years just like drop column was.
Feel free
Sorry sorry
ID-10-T error
Cheers
JL
-Original Message-
Sent: Wednesday, February 14, 2001 9:19 AM
To: '[EMAIL PROTECTED]'
Wait wait wait...
Yes you can rename a column in 8i, it just depends to what value your
compatibility parameter is set
Regards
JL
-Original Message-
Sen
Well, it isn't recommend it but you can update the field name of sys.col$
table.
Regards.
> -Mensaje original-
> De: bipin sahani [SMTP:[EMAIL PROTECTED]]
> Enviado el: miƩrcoles 14 de febrero de 2001 7:05
> Para: Multiple recipients of list ORACLE-L
> Asunto:
i think u can't rename a column. it's still under consideration.
if u can, pls mention with some more specific syntax.
it'll b helpful for all.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 12:50 PM
> Wait w
Behalf Of bipin sahani
Sent: Wednesday, February 14, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Renaming a Column
In Oracle
It's not possible to rename a column.You can instead
use alias for that column name in your queries.
Or you have to create a new table
if it is oracle 815 onwards
insert new column in the table.
insert data into new column from the old column in the table
alter table drop column
Thanks & Regards
Ram
Message History
---
Wait wait wait...
Yes you can rename a column in 8i, it just depends to what value your
compatibility parameter is set
Regards
JL
-Original Message-
Sent: Wednesday, February 14, 2001 8:05 AM
To: Multiple recipients of list ORACLE-L
In Oracle
It's not possible to rename a column.You c
CREATE THE TABLE AGAIN WITH AS SELECT CLAUSE..
SELECTING ONLY COLUMN DEFINITION WHILE SUPPLYING THE NEW COLUMN NAME URSELF.
apply constraints if any.
reinsert the data from old table. drop old table . rename new table as old
one.
- Original Message -
To: Multiple recipients of list ORACLE-
Hessu,
One of the ways:
create table newtable (newcolumn1,newcolumn2,newcolumn3,...)
as select * from oldtable
;
rename newtable to oldtable;
HTH
Suhen
Hi all,
I need to rename some columns on my table. Any idea how to do that...
Thanks in advance,
Hessu
___
In Oracle
It's not possible to rename a column.You can instead
use alias for that column name in your queries.
Or you have to create a new table from existing one
Drop existing table.And recreate a table by
selecting from new table.
Regards
Bipin
--- Heikki Jantunen <[EMAIL PROTECTED]> wrote: >
H
Hi all,
I need to rename some columns on my table. Any idea how to do that...
Thanks in advance,
Hessu
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: h
29 matches
Mail list logo