7 Replies Latest reply: Oct 15, 2012 9:41 AM by Sunny kichloo RSS

    ORA-39001 ORA-39170

    934646
      HI,

      While i was doing export I got the following error:

      ORA-39001: invalid argument value
      ORA-39170: Schema expression 'PUBLIC' does not correspond to any schemas.

      the command I used :
      C:\Documents and Settings>expdp directory=export_dump_dir dumpfile=public.dmp logfile=public_exp.log schemas=PUBLIC parallel=2

      My env windows server 2008 oracle 10.2.0.4

      Thanks
        • 1. Re: ORA-39001 ORA-39170
          Paul M.
          ORA-39170: Schema expression 'PUBLIC' does not correspond to any schemas.

          the command I used :
          C:\Documents and Settings>expdp directory=export_dump_dir dumpfile=public.dmp logfile=public_exp.log schemas=PUBLIC parallel=2
          Well, isn't the error clear enough ?
          $ oerr ora 39170
          39170, 00000, "Schema expression %s does not correspond to any schemas."
          // *Cause:  A schema expression or schema list was supplied for a Data Pump
          //          job that did not identify any schemas in the source database.
          // *Action: Correct the schema specifications and retry the job.
          $
          PUBLIC is a role.
          • 2. Re: ORA-39001 ORA-39170
            934646
            Hey Paul M. thanks for the early reply...

            PUBLIC is a schema and there is no spelling mistake with the schema name. This is not application schema, this is system default schema. But there are some synonyms(Public synonyms) in this schema which belong to some application schemas. Can`t we export and import system schemas?

            thanks
            • 3. Re: ORA-39001 ORA-39170
              Paul M.
              This is not application schema, this is system default schema.
              Not sure to understand what that means...
              • 4. Re: ORA-39001 ORA-39170
                934646
                system schema means, schema that was created at the time of database creation. This was not created by us.
                • 5. Re: ORA-39001 ORA-39170
                  Paul M.
                  system schema means, schema that was created at the time of database creation. This was not created by us.
                  Then it's not a schema, it's a role.
                  • 6. Re: ORA-39001 ORA-39170
                    934646
                    how to export synonyms under that role?
                    • 7. Re: ORA-39001 ORA-39170
                      Sunny kichloo
                      Please refer below mentioned link

                      Role

                      http://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm



                      Schema

                      http://docs.oracle.com/cd/B28359_01/server.111/b28318/schema.htm


                      Exporting Synonym Using EXPDP

                      export of public synonym in oracle

                      and

                      http://www.pythian.com/news/272/oracle-data-pump-schema-export-and-public-synonyms/