Is This Content Helpful?
We're glad to know this article was helpful.
"Failed to register as versioned.
Underlying DBMS error [ORA-00984: column not allowed here][TEST.TEST.VIRTUAL]"
With the release of Oracle 11G virtual columns are a new feature. Tables within Oracle that contain virtual columns cannot be registered as versioned.
The example below shows the creation of a table using SQL*Plus, adding two column names, inserting values, and adding a virtual column concatenating the fname and lname columns.
create table test_virtual (fname varchar2(25), lname varchar2(25));
insert into test_virtual values('Albert','Einstein');
alter table test_virtual add (fullname varchar2(60) generated always as (fname||' '||lname) virtual);
The attribute data within the table can still be viewed, but currently the use of tables with virtual columns in a versioned environment is not supported.