Exporting a schema which contains a dot in the name with EXPDP fails with ORA-39001, ORA-39170
Last updated on OCTOBER 25, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
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=L.LASTRUCCI directory=dp_dir dumpfile=ll.dmp
Export: Release 188.8.131.52.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 184.108.40.206.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39170: Schema expression 'L' does not correspond to any schemas.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms