Home » RDBMS Server » Server Administration » how to change the exiting filedname to new filedname
how to change the exiting filedname to new filedname [message #51939] Sat, 22 June 2002 03:44 Go to next message
Fareez
Messages: 1
Registered: June 2002
Junior Member
Hi pals,
i have a query that how to change the existing filedname to new filedname in Oracle pl give me the solution and the syntax
thanks
fareez

Report message to a moderator

Re: how to change the exiting filedname to new filedname [message #51975 is a reply to message #51939] Mon, 24 June 2002 12:49 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I think that is only supported in 9iR2. The usual way is to create a new table with the correct field names; insert your data from the old table into that; drop the old table; rename the new one etc. If you have relationships from that table then it's a pain. You can also just rename the table and create a view using the name you want with the column names you want. As long as that table has a PK then you can insert/update/delete the view as with the table.

Report message to a moderator

Previous Topic: Which transaction is using which ROLLBACK SEGMENT
Next Topic: Rollback Segments
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:34:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.