I was doing an import of a database *(schema)* from a previous version *(Oracle 10g express editon)* to a more recent version *(Oracle 11g express edition)* in Oracle from a `.dmp` file *(I did not export, I was only responsible for make the import into the new environment)*, the way to do it I consulted in a previous forum and I managed to import using `imp`, I could not use the `impdp` because the export was not done with the `expdp`.

Well, once the restoration was done what I needed most was to restore all the objects in another tablespace, for that I had previously created a user, a tablespace associated with that user and naturally a datafile associated with that tablespace. But all the objects had been restored within the system tablespace (`USERS`), since in the source database these are in that tablespace.

The instruction that I used and thought would help me was the following:

```
imp my_user/password@XE FILE=C:\oraclexe\app\oracle\admin\XE\dpdump\my_file.dmp FROMUSER=my_user TOUSER=my_user

```

However, even though I tried to change the user (`FR0MUSER` and `TOUSER`), the data is still restored in the `USERS` tablespace and also in `SYSTEM`.

I guess the only way to solve this is to export again. I have three options: The `exp`, `expdp` and the `RMAN`. Although I am not sure that these help me alone to change or modify the destination tablespace.

Any reference would be very helpful.