2

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?

|improve this question
1

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

EXCLUDE=SCHEMA:\"IN\(\'SYS\',\'SYSTEM\',\'OUTLN\',\'ORDDATA\',\'OLAPSYS\',\'MDDATA\',\'SPATIAL_WFS_ADMIN_USR\',\'ANONYMOUS\',\'SPATIAL_CSW_ADMIN_USR\',\'ANONYMOUS\',\'FLOWS_FILES\',\'APEX_PUBLIC_USER\',\'APEX_030200\',\'OWBSYS\',\'OWBSYS_AUDIT\',\'SCOTT\',\'SYSMAN\',\'MGMT_VIEW\'\)\"

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

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

|improve this answer
  • i know that way . but is it good to do because currently we have around 30 oracle default users – vvs Jul 2 '18 at 11:16
  • @ws That is normal if you have multiple additional options installed. – Balazs Papp Jul 2 '18 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 – vvs Jul 2 '18 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/… – Balazs Papp Jul 2 '18 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 '18 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.