"export user objects" of table with virtual column creates wrong data type

[Bernhard S]

I create the following table which includes a virtual column of data type varchar2(3):

create table ta_my_test
( a number
 ,b varchar2(3) generated always as ( 'XYZ')
);

When I export this table using PL/SQL Developer "Export User Objects" I get:

create table TA_MY_TEST
(
  a NUMBER,
  b as ('XYZ')
)
;

This however result in a table with virtual column data type char(3) instead of the varchar2(3), which I had before

 

[Marco Kalter]

We'll check it out.