Exporting a schema which contains a dot in the name with EXPDP fails with ORA-39001, ORA-39170
(Doc ID 388763.1)
Last updated on MAY 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
This problem can occur on any platform.
While exporting a schema with the datapump export utility the following errors occur :
$ expdp schemas=<NAME1>.<NAME2> directory=dp_dir dumpfile=<DUMP_NAME>.dmp
Export: Release 220.127.116.11.0 - Production on Wed Aug 17 04:59:44 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39170: Schema expression '<NAME1>' does not correspond to any schemas.
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