i created the user like this
create user se_billing identified by billing default tablepsace mytbs;
but when i am importing a .dmp file to into this user it is importing
to system tablespace only. i.e i observed all segments are in
system tablepace only. what to do?
while importing should i specify tablepsace to which i want to import.
the problem all the tables were in the system tablespace in the original database, dont give yourself access to the system tablespace in your new database and the tables will go into your default tablespace
Right Davey :-)
To be more specific, revoke the RESOURCE role from the destination user, then
alter user YOUR_USER quota 0 on SYSTEM
alter user YOUR_USER default tablespace SOME_TABLESPACE
alte user YOUR_USER quota unlimited on SOME_TABLESPACE