impdmp remap_tablespace parameter

Hi

I need to remap multiple tablespaces using the imp command.

Can somebody help me with this

I tried

Code:

---

impdp REMAP_TABLESPACE=DATA_MEDIUM:USERS remap_tablespace=DATA_LARGE:USERS     
remap_tablespace=DATA_MEDIUM:USERS remap_tablespace=DATA_HUGE:USERS     
remap_tablespace=DATA_TINY:USERS 
remap_tablespace=DATA_PIC:USERS
SCHEMAS=OWNER  directory=my_dir dumpfile=ema_owner_meta.dmp logfile=hrishy.log

---

But it fails with a error message saying
ORA-39001: invalid argument value
Metadata remap REMAP_TABLESPACE has already been specified

Any help on getting the syntax right

regards
Hrishy

You cannot include more than one remap_tablespace parameter per source tablespace; as I can see you are writting two remap_tablespace for source tablespace DATA_MEDIUM

Hi Pavb

Thanks for spotting that error :-).
It is running now

regards
Hrishy