I need help with impdp. I have taken a backup with:

expdp system/pw@orcl full=y directory=abc dumpfile=full.dmp

Now I need to import the dump into another instance, which has recently been created. I was going to import the full database dump, but it raises an error when an object already exists.

However, these objects belong to Oracle's default schemas, which I can not remove. How do I avoid these import errors?

1 Answer 1


Exclude the schemas with the exclude parameter. E.g:


The list of schemas depends on the database version and options installed.

In a parameterfile, you can use the above without \ (escaping special characters).

  • i know that way . but is it good to do because currently we have around 30 oracle default users
    – Ray
    Jul 2, 2018 at 11:16
  • @ws That is normal if you have multiple additional options installed. Jul 2, 2018 at 11:25
  • its works good . but is there anything to find out default users because there is still some users are different from other instance
    – Ray
    Jul 2, 2018 at 11:41
  • 1
    @ws Here is the list of default users in version 11.2: docs.oracle.com/cd/E11882_01/install.112/e47689/… Jul 2, 2018 at 11:48
  • 2
    Maybe you are looking through the wrong end of the telescope. Instead of trying to skip an extensive list of 'default' schemas, you just use the SCHEMAS parameter to list what should be relatively few application schemas.
    – EdStevens
    Jul 2, 2018 at 16:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.