ORA-39039: Schema expression " IN contains no valid schemas
                                                 Last update (2012-04-25 02:16:37)
                                                                                                                   Date added (2012-04-25 02:10:09)

Summary
Datapump Import Fails With ORA-31655 and ORA-39039.
ORA-31655: no data or metadata objects selected for job
ORA-39039: Schema expression " IN ('schema name')" contains no valid schemas
Solution: Remove the SCHEMAS=schema_name from the impdp statement. The original export was performed on Table Mode, so don't try to import on Schema level!
Reviews
Filters
Search