Summary: Problem with export (maybe...terminated successfully with warnings) and import (IMP-00022: failed to process parameters)
I used PL/SQL developer to make a parameter file (initially I used it to export, then I just stole the file to try again). It contains 100 tables from a single schema.
Export from prod DB using exp parfile=test.par:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table CONTRACT_INFO 12 rows exported
EXP-00091: Exporting questionable statistics.
'Export terminated successfully with warnings.' !!!
I want to import into the cs2_user schema (same privileges as on the production DB) trying:
impdp 'sys as sysdba'@danieldb schemas=cs2_user dumpfile=test01tables3.dmp
That gets the error:
UDI-00014: invalid value for parameter, 'attach'
I then thought maybe you have to use imp/exp or impdp/expdp instead of a combination (exp + impdp) so I tried:
imp 'sys/admin as sysdba'@danieldb touser=cs2_party_owner file=test01tables4.dmp
but then I just get:
IMP-00022: failed to process parameters
Anyone see why its all failing? :s
Mike