importing to a specified tablespace only

[madhugp]

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.
plz suggest

thanks

[patel_dil]

There is no to tablespace option while import so you cannot use it. What is your oracle version and what syntax are you using to import. Do you have fromuser, touser in it?

[davey23uk]

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

[Bore]

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

and here we go

Good luck

[cis_groupie]

If importing in 10g you can specify a 'to' tablespace.

[Bore]

And if you use DP