3. orcle import the DMP file and change the tablespace

1. Import the DMP file and modify the tablespace

Impdp user/[email protected] dumpfile = 20140820.dmp remap_tablespace = liveoa: liveoagd full = y

Note: User/[email protected]: User Name/password @ database instance name

20140820. dmp: Path of the DMP file to be imported

Remap_tablespace = liveoa: liveoagd: liveoa is the previous tablespace name and liveoagd is the new tablespace name.

2. Import the DMP file without modifying the tablespace

IMP user/password file = C: A. dmp log = C: A. Log full = y ignore = y