Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3304
  • Last Modified:

Not able to import using Data pump

Hi
I exported  entire scott  database  using  expdp now but unable to  import one table from this  dmp   to my HR  schema..  my impdp command is as follows ..

C:\> impdp hr/hr  tables=scott.emp directory=dpump_dir dumpfile=dpump_dir:scott.dmp  logfile=dpump_dir:scott.log

I tried all alternates like changing username  and pwd from hr/hr  to scott tiger ,, i tried with  even schema option ,, but nothing   worked .. it  imports in own  schema  but not in other schema .. I just want to  import this  object from scott  schema to hr  schema..
Here output from my log file

;;;
Import: Release 10.1.0.2.0 - Production on Tuesday, 13 June, 2006 10:18

Copyright (c) 2003, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "HR"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "HR"."SYS_IMPORT_TABLE_01":  hr/******** directory=dpump_dir dumpfile=dpump_dir:scott.dmp logfile=dpump_dir:scott.log tables=scott.emp
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-31684: Object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OBJECT_GRANT
ORA-39111: Dependent object type OBJECT_GRANT:"RHM_ROLE" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"PUBLIC" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"HR" skipped, base object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39111: Dependent object type INDEX:"SCOTT"."PK_EMP" skipped, base object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39111: Dependent object type CONSTRAINT:"SCOTT"."PK_EMP" skipped, base object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SCOTT"."PK_EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39111: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39111: Dependent object type REF_CONSTRAINT:"SCOTT"."FK_DEPT" skipped, base object type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39111: Dependent object type TRIGGER:"SCOTT"."DEL_EMP_TRIG" skipped, base object type TABLE:"SCOTT"."EMP" already exists
Job "HR"."SYS_IMPORT_TABLE_01" completed with 20 error(s) at 10:18
0
rehman123
Asked:
rehman123
1 Solution
 
jwahlCommented:
to import in another schema add  FROMUSER=<username> TOUSER=<username> to the parameters.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now