Moving objects from one tablespace to other tablespace
myraMay 25 2011 — edited May 25 2011Hi Guys,
I want to create the schema with same name. Can anyone let me know what could be the better way. DB version is 11gR2 on windows.
1. I have schema ABC in XXX tablespace . I did expdp of ABC. Created new user xyz in YYY tablespace (as per requirement) and imported data of ABC and dropped it. But I want to have user ABC in YYY tablespace. How that can be achived.
2. My requirement is to move certain schemas to new tablespace but schema name cannot be different after the data movement is done.
3. If ABC is by default in XXX tablespace and I just change the default tablespace for user ABC after few months then will it affect any way from application access point of view and on user level, since it will have some data in old tablespace and new data would be in new default tablespace.
Kindly advice.
Thanks...Mayura