I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question.
What i wanted to do is to import all contents from dump file to another database which has a different schema. I tried the command below but got error since oracle doesn't allow SYSTEM to SYSTEM remap.
C:\>impdp SYSTEM/password@testing directory=imp_dir dumpfile=dumpFile.dmp logfile=dump_log.log full=yes remap_schema=SYSTEM:SYSTEM
My question is there a way to import all contents of dump file without having to repeat the command below over and over again until all schemas are copied? Thanks
C:\>impdp SYSTEM/password@testing directory=imp_dir dumpfile=dumpFile.dmp logfile=dump_log.log full=yes remap_schema=schema1:schema1