Database Utilities (MOSC)

MOSC Banner

IMPDP causing ORA-39002 with no subsequent message

Hi,

I am facing ORA-39002 followed by subsequent errors providing more detail on the issue. Gone through many articles but no luck. So, kindly need your assistance/support to resolve this issue.


========================Export========================================

Export: Release 19.0.0.0.0 - Production on Wed Jan 18 14:20:34 2023

Version 19.12.0.0.0

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

;;; 

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Starting "SYED"."SYS_EXPORT_SCHEMA_01": syed/******** directory=dump dumpfile=DEV_MD-TP-VER.DMP logfile=dev_md-tp.log metrics=Y compression=ALL exclude=statistics content=metadata_only version=18 schemas=TPAUSER 


===========================Import======================================


C:\Users\Administrator>impdp directory=DATA_PUMP_DIR dumpfile=DEV_MD-TP-VER.DMP logfile=tp-ver.log schemas=TPAUSER remap_schema=tpauser:tpauser

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