Re: How to change column names?

From: Steve Mitchell <steve_at_mitchells.demon.co.uk>
Date: 1998/09/30
Message-ID: <3612B26B.45ECE528_at_mitchells.demon.co.uk>#1/1

> this is definitely possible. i have a similar script and have used it
> several times. it is UNSUPPORTED and you will have to bounce the instance
> to see the change, but it beats the hell out of copying the whole table.

I did do this myself once when I couldn't be bothered to create a new table with a change of name to just one column so I directly alter the data in the data dictionary in COL$. Instead of restarting the instance I just flushed the shared pool and the column was renamed. Don't recommend it in a production environment though.

Steve Received on Wed Sep 30 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: Carl Alex Friis Nielsen: "Re: Differences Oracle 7.1 and Oracle 7.3 / 8.0"
Previous message: brownb6483_at_my-dejanews.com: "Re: OWAS Handbook examples code where?"
Maybe in reply to: Winnie Liu: "Re: How to change column names?"
Next in thread: Carl Alex Friis Nielsen: "Re: Differences Oracle 7.1 and Oracle 7.3 / 8.0"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message