Still Having A Problem With Import
I'm sorry to keep bother everybody about this, but my import is still going to the wrong tablespace...
Update:
1) I have altered the "new_user" to have 0 quota on the old_tablespace (as suggested here).
2) I have granted this user unlimited quota on the new_tablespace.
3) I re-exported the data from the old_tablespace using with the following options:
a) userid=newuser, fromuser=new_user, touser=new_user
b) userid=old_user, fromuser=old_user, touser=new_user
c) userid=new_user, fromuser=new_user, touser=new_user
d) userid=new_user, fromuser=old_user, touser=new_user
e) userid=DBA, fromuser=old_user, touser=new_user
f) userid=DBA, fromuser=new_user, touser=new_user
The reason I tried the export with the "new_user" is a query of dba_tables (and user_tables logged in as the new_user), shows the tablespace the tables or now located (after 2 imports into the wrong tablespace), in as the old tablespace.
Using the "show=y" parameter on the import tells me that all the tables in the export file are going to be created in the old_tablespace, regardless of which options (a-f) above I choose.
How can the import insert rows in tables in the old tablespace when I have set the quota to 0 for the new_user on the old tablespace, and running the import with the new_user as the "userid=", with it's default tablespace defined as the new tablespace ?