Hi All,
Good morning and greetings for the day
I am facing a strange issue. May be I am seeing or knowing it for the first time.
I created a virtual column in one of our master tables for computing a value, using CASE statement.
Afterwards, I had to do a correction in the CASE statement, and hence I dropped the virtual column.
But in the data dictionary, the reference for the virtual column still remains as a HIDDEN VIRTUAL COLUMN.
Below query will give you the column list of the particular table.
SQL>select * from dba_tab_cols where table_name='<table_name>' order by column_id;
And it says YES for Hidden and Virtual attributes,meaning it is a hidden virtual column.
Below is the hidden Virtual Column naming format.
SYS_C000<col_id>_YYMMDDHH24:MI:SS$
eg: SYS_C00062_15070809:45:12$, which means that this virtual column was created on 08-July-2015 9:45:12 AM and later it was dropped.
I want to remove this hidden virtual column information because it is somewhat disturbing to see, although it is not making any issues.
I tried to drop this column with this name format, but didn't succeed.
I checked in metalink but didn't find anything related to this.
Appreciate your help in this regard.
Thanks & regards,
Mahesh Menon Kayappurath.