Say the second schema is TEST2 with default tablespace TS2.
Now we have to move some objects from TEST1 schema to TEST2 schema.
Consider the following syntax ..
Does export and import work ? Lets try ....
This should actually move the table TABLE1 from TEST1 to TEST2.
But if you observe the table TABLE1 after the import it is in schema TEST2 which is ok but tablespace is still TS1. WHY ?
The user TEST2 has default tablespace TS2, so when we import the table it should be created in TS2 tablespace. Why is it created in TS1?
Then what is the solution to move an object to TEST2 with tablespace TS2. !!!!!!!
Follow the following steps to move the objects to different schema with different tablespace.
Then verify the object schema and tablespace. It should be TEST2 with TS2.
Hope it helps ....