import tables impdp

[Roshan]

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

[ErmanArslansOracleBlog]

Hi Roshan, let me get back to you.

[ErmanArslansOracleBlog]

Hi Roshan,

Do you have "db_cc" user/schema in your souce database where you exported your dump?
If you don't have this schema in your source database, then you will need to use "remap_schema".

[Roshan]

It's ok. The db_cc user was for a different dumpfile. Now it's ok