My Oracle Support Banner

Using Version=10.2 In Datatpump Skips Few Tables In 12c (Doc ID 1930667.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database - Standard Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

DataPump export on 12, using 'version=10.2' like

system/********@db dumpfile=test1.dmp logfile=10version.log tables=table_name version=10.2


a few tables are skipped and errors like below are reported:

Export: Release 12.1.0.1.0 - Production on Thu Sep 18 03:05:50 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/********@12db dumpfile=test1.dmp logfile=10version.log tables=owner.table_name version=10.2 TRACE=480301
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object owner.table_name was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Thu Sep 18 03:06:42 2014 elapsed 0 00:00:45

 

Changes

Extended statistics are created on the table, which is a feature first introduced in 11g.

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