Database Utilities (MOSC)

MOSC Banner

impdp log file missing entry for table partition

edited Feb 7, 2017 4:00AM in Database Utilities (MOSC) 3 commentsAnswered

DATABASE

Oracle Database Enterprise Edition 11.2.0.4

SCENARIO

Exporting (expdp) from an 11.2.0.4 databaes on RHEL 5.6

Importing (impdp) into a new, empty 11.2.0.4 database on RHEL 6.6

FINDINGS

According to the expdp log 181 partitions with a total of 22,539 rows were exported for a particular table from the source database. These numbers were confirmed by counting the number of partitions for this table (from dba_tab_partitions) and by counting the number of rows from the table (NOT using num_rows from dba_tables).

According to the impdp log 180 partitions totaling 22,140 rows were imported into the target database. The one partition (P_158) that is not in the impdp log shows in the expdp log as having 399 rows.However, in the target database when I count the total number of rows for this table I get 22,539 and when counting the number of partitions for this table I get 181 partitions including partition P_158 which does not appear in the impdp log. These numbers match the counts in the source database; i.e., only the impdp log differs. It appears as if the partition

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center