ORA-54013 Raised During Network Link Import Of Tables With Virtual Columns (Doc ID 1305849.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

You created a table with a virtual column (like in the example below):

connect test/password
create table a_table_with_virtual_column
(
   id      number,
   text    varchar2(10),
   vc_text varchar2(10) generated always as (upper (text)) virtual visible
);

insert into a_table_with_virtual_column (id, text) values (1, 'Text 1');
commit;

select * from a_table_with_virtual_column;

ID         TEXT       VC_TEXT
---------- ---------- ----------
         1 Text 1     TEXT 1

Now you try to import the table using a network link into a remote target database:

#> impdp test/password directory=dpu network_link=test tables=test.a_table_with_virtual_column

This ends with:

Import: Release 11.1.0.7.0 - Production on Monday, 21 March, 2011 9:31:51

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Starting "TEST"."SYS_IMPORT_TABLE_01": test/******** directory=dpu network_link=test tables=test.a_table_with_virtual_column
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "TEST"."A_TABLE_WITH_VIRTUAL_COLUMN" failed to load/unload and is being skipped due to error:
ORA-54013: INSERT operation disallowed on virtual columns
Job "TEST"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 09:32:04

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms