I'm trying to export the contents of a table containing a virtual column to a csv file, and then import it into another database:
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
set sqlformat csv
spool sometable.csv
select * from some_table;
output includes the virtual column, and when I try to load it, I get:
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
load sometable sometable.csv
--Insert failed in batch rows 1 through 20
--ORA-54013: INSERT operation disallowed on virtual columns
So I repeat the export process, selecting individually named columns instead of all columns.
This time, when I import it, I get this message:
--Omitted columns must be nullable
--Number of rows processed: 0
--Number of rows in error: 0
3 - SEVERE: Severe error, processing terminated
To be clear, the virtual column is nullable.
Any ideas?