Dear,
I have a T1 table with a COL1 char (5) column and I need to change it to varchar2 (5), when I do it it gives me the ORA-54033 error.
I look for the virtual columns with:
select column_id, column_name, virtual_column, data_default
from user_tab_cols
where table_name = 'T1'
and virtual_column = 'YES'
bring back:
COLUMN_NAME VIR DATA_DEFAULT
-------------------------------------------------------------------------------------------------------------------------------- --- --------------------------------------------------------------------------------
SYS_STS7G2MO8R1$D#$5M6QGZF3H7T YES SYS_OP_COMBINED_HASH("CONVENIO","DOCTO_TIPO","TIPO_EMAIL")
when I try:
alter table T1 drop column SYS_STS7G2MO8R1$D#$5M6QGZF3H7T;
bring back:
alter table EMAIL_FORMATO drop column SYS_STS7G2MO8R1$D#$5M6QGZF3H7T
Informe de error -
ORA-12996: no se puede borrar una columna virtual generada por el sistema
12996. 00000 - "cannot drop system-generated virtual column"
*Cause: An attempt was made to drop a virtual column generated by
the system.
any idea of solution?
Thank you so much
Carlos