My Oracle database : 10G
I am not a DBA but I am stuck what looks like a simple operation, here is the context
I have exported 2 tables of HR schema using expdp and here is the command:
C:\>expdp hr/hr@ORCL tables=EMPLOYEES,DEPARTMENTS directory=ORACLE_BKP dumpfile=hr_e_d.dmp logfile=hr_e_d.log
so this part uptill now is without any issues, Now I am trying to use this dmp file 'hr_e_d.dmp' and want to put both these tables in a different schema which is pkg_utils and here is the command which is throwing the error:
C:\>impdp pkg_utils/pkg_utils@ORCL schemas=HR directory=ORACLE_BKP1 dumpfile=hr_
Import: Release 10.2.0.1.0 - Production on Sunday, 08 September, 2013 14:51:04
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
With the Partitioning, OLAP and Data Mining options
ORA-31655: no data or metadata objects selected for job
ORA-39039: Schema expression " IN ('HR')" contains no valid schemas.
Master table "PKG_UTILS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "PKG_UTILS"."SYS_IMPORT_SCHEMA_01": pkg_utils/********@ORCL schemas=HR
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Job "PKG_UTILS"."SYS_IMPORT_SCHEMA_01" successfully completed at 14:51:05
PS: the requirement is only to export employees,departments tables of HR schema to pkg_utils schema
Thanks PaulM for the reply and Its working fine ie crossed 1 hurdle but stuck on the other, now I believe the HR schema objects are laying on the examples tablespace and the pkg_utils user has default tablespace as : pkg_utils(at the time of creating this user I gave the option -> quota unlimited on tablespace pkg_utils), could you please help me cross this hurdle also.