I have created a user and tables in that. I did not mention the default tablespace and user is created with USERS tablespace by default.
If i change the user tablespace to another one, whether it transfer all tables from old tablespace to new one ? or i need to use alter table move tablespace for all tables and dependent objects ?