I want to assign a new name to a table colum. I have already some data input into the database.
I have access, as SYS user, to the Oracle data dictionary col$ and change the name.
Checking the name on the table appears the new one, but when through the DBA Studio I try to access the data does not allow me. Thougth sqlplus the name is the old one.
I have a form corresponding to that table, and the name seems to be the old one, so I gives an error when executing a Query or trying to save a new value.
1st off.... Never mess with the SYS tables ... you now have a descripency with other tables (user_tab_columns, etc ...)
If you are using Oracle 8 ... you need to either 1. rebuild the table
(possible build a new table and populate it with the data from the
original table ... drop original table, rename new table)
Add a new column to the existing table and populate it with the data
from the original column, then drop the old column...
Cleanest ... create new table, populate it with data from the original
table, drop old table, rename new table ... Remember you have
invalidated indexes and any other dependency objects (triggers, procs...)