I read some docs but i found examples for partitioned tables movement
only...read more...search more...
Sorry, but im quite confused....what is meant by tablespaces are within schema? Does it mean both are granted resource to the user?
Say, if i have schema or user SCOTT, and i have 2 tablespaces TBLSPC1,
and TBLSPC1, and i granted resource on these tablespaces to SCOTT,
SQL> grant resource on TBLSPC1,TBLSPC2 to SCOTT;
And if i have a table EMP on SCOTT, i can do this...