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 to [Release 11.2 to 18]
Information in this document applies to any platform.


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 - 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 -
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>
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
ORA-39164: Partition <OWNER>.<TABLENAME>:<PARTITIONNAME1> was not found.
ORA-39164: Partition <OWNER>.<TABLENAME>:<PARTITIONNAME2> was not found.



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.