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 NOVEMBER 12, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
This problem can occur on any platform.
Symptoms
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 11.2.0.4.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 11.2.0.4.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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |