import tables impdp

Posted by Roshan on Mar 08, 2017; 4:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-tables-impdp-tp2293.html

Hello Erman,

I am importing only tables for a user db_cc.

impdp db_cc/db_cc123 dumpfile=PMTBIL01070320172359.dmp directory=dumps  tables=db_cc.Contract,db_cc.Account,db_cc.Customer,db_cc.Inst_attr,db_cc.Inst_srv logfile=imp1.log

I am getting the error below despite one schema was given

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39040: Schema expression "SCHEMAS" must identify exactly one schema.

Grateful if you can help

Regards,

ROshan