Exporting schema into different tablesapce

[rishiu]

I have a user whose default tablespace is SYSTEM,
when i export it and import it into another database again
it gets imported into the same system tablespace.(although
the default tablespace of that new user is USERS)
here is the question:
How can i change the tablespace for a particular user if
the exported user;s tablerspace is SYSTEM. Or u can
say How can i change the schema;s tablespace.? so that whole of
that schema's objects gets into another tablespace?

 

[THoey]

Try this when no one is hitting those tables:

ALTER TABLE YourTable MOVE TABLESPACE NewTablespace;
Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[THoey]

Sorry, I guess that is not quite complete. I would use that command to move all of the User's tables and then make sure you do an ALTER USER to change their default tablespace.

Hope that is better... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[carp]

In addition to changing the default tablespace, be sure to revoke their quota on the SYSTEM tablespace; otherwise, the objects may wind up in there again!

 

[rishiu]

Hai there!
Thks for the inputs , but it doesn;t sees to b good option bcoz there are hundreds of tables in that schema.
Here is what i did.

Revoke special permissions from the new users.
make quota 0 on sysstem tableaspace, make it form all the
tables in default tablespace n then grant the permission
after import again.
Thks for the responses
Rishi