Failed to register as versioned. Underlying DBMS error [ORA-00984: column not allowed here][user.table]

Error Message

"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.

Cause

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.

Code:
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);

Solution or Workaround