My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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');

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.