My Oracle Support Banner

EXP-10 Usernames Which Cannot Be Exported (Doc ID 217135.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Export utility will return the error:

EXP-00010: %s is not a valid username or not an exportable username.


when exporting the following schemas:

- ORDSYS
- MDSYS
- CTXSYS
- ORDPLUGINS
- LBACSYS
- XDB

In 10g the list has been expanded by additional users:

- SI_INFORMTN_SCHEMA
- DIP
- DMSYS
- DBSNMP
- EXFSYS
- WMSYS

In 11gR1 the list has been expanded by additional users:

- ORACLE_OCM
- ANONYMOUS
- XS$NULL

In 11gR2 the list has been expanded by user:

- APPQOSSYS

Changes

 NONE

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!

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