My Oracle Support Banner

Import Fails With ORA-39164 When Importing Multiple Partitions From Read Only Database Over The Network Link OR DB link (Doc ID 2420827.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 18.3.0.0.0 [Release 11.2 to 18]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or built-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 

Import is failing with error ORA-39164 when importing multiple partition from read only database with over the network link /DB link.

Error Message:

Import: Release 12.1.0.2.0 - Production on Thu May 17 23:04:15 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
Starting "SYSTEM"."SYS_IMPORT_TABLE_04": system/******** network_link=<LINKNAME>
 TABLES=<OWNER>.<TABLENAME>:<PARTITIONNAME1>,<OWNER>.<TABLENAME>:<PARTITIONNAME2>
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151: Table "<OWNER>"."<TABLENAME>" exists. All dependent metadata and
data will be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39164: Partition <OWNER>.<TABLENAME>:<PARTITIONNAME1> was not found.
ORA-39164: Partition <OWNER>.<TABLENAME>:<PARTITIONNAME2> was not found.

 

Cause

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
Symptoms
Cause
Solution
References


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