Follow below steps to Import Oracle dump into different Tablespace With your .DMP file, create a SQL file containing the structure (Tables): imp <username>/<password>@<sid> file=<filename.dmp> indexfile=index.sql full=y Open the indexfile (index.sql) in a text editor and issue the following find and replace statements IN ORDER (ignore the single quotes): Find: ‘REM<space>’ Replace: <nothing> Find: ‘”<source_tablespace>”‘ […]