Database Utilities (MOSC)

MOSC Banner

ORA-39246: cannot locate master table within provided dump files

edited Feb 1, 2018 2:09PM in Database Utilities (MOSC) 4 commentsAnswered

Hello team,

we are using GG to replicate the 11.2.0.3 to 12.2.x.x container DB (PDB). we are using expdp for initial load.

we have encountered error during import.

Import: Release 12.2.0.1.0 - Production on Fri Jan 19 11:28:24 2018

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

ORA-39002: invalid operation

ORA-39059: dump file set is incomplete

ORA-39246: cannot locate master table within provided dump files

cat expdp.par

dumpfile=GGDIR:dbname_full_%u.dmp

logfile=GGDIR:dbname_full_exp.log

VERSION=12

flashback_scn=123456789

full=y

parallel=10

cat impdp.par

dumpfile=GGDIR:dbname_full_%u.dmp

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