My Oracle Support Banner

DataPump Import (IMPDP) Fails With ORA-39005 ORA-39230 (Doc ID 2273683.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

A 12.1.0.2 DataPump Import job started with the following parameters:

CONTENT=ALL
STATUS=0
JOB_NAME=IMPDPSCHEMA2
SCHEMAS=BTMSDBA
SERVICE_NAME=BTMS_DEV

 
errors out with:

> IMPDP SYSTEM@BTMS_DEV PARFILE=parfile.par

Import: Release 12.1.0.2.0 - Production on Mon Jun 5 09:34:58 2017

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39005: inconsistent arguments
ORA-39230: Service name BTMS_DEV is not available

 

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.