This content has been marked as final. Show 7 replies
ORA-39170: Schema expression 'PUBLIC' does not correspond to any schemas.Well, isn't the error clear enough ?
the command I used :
C:\Documents and Settings>expdp directory=export_dump_dir dumpfile=public.dmp logfile=public_exp.log schemas=PUBLIC parallel=2
PUBLIC is a role.
$ 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. $
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?
This is not application schema, this is system default schema.Not sure to understand what that means...
system schema means, schema that was created at the time of database creation. This was not created by us.
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.
how to export synonyms under that role?
Please refer below mentioned link
Exporting Synonym Using EXPDP
export of public synonym in oracle