Best Practice to Copy Table to Different Schema?
603447Dec 20 2010 — edited Dec 21 2010This is what I tried:
1. Create USER2 new user that uses TBS2 as default Tablespace
2. Perform exp (resides on TBS1 Tablespace)
3. Perform imp using fromuser and touser parameter to USER2
What I noticed is that the table that was imported to USER2 still resides on the same tablespace which suppose to be on TBS2.
Can someone help me perform this steps?