Unanswered: Importing a dump file into a different tablespace
Here is my problem. I have a schema 'msdb1'. The default tablespace for the user is msdb1. I have exported from the schema, and want to import the dump file into a new user 'msdb2', which has a default tablespace msdb2. But when I have run the import, the tablespace for all of the tables in the new msdb2 schema is still msdb1. How can I export/import so the tables in the msdb2 schema use the msdb2 tablespace? Nothing I have tried has worked. I am importing and exporting using command line.