|
-
Thanks hunie,
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...
SQL> alter table EMP move tablespace TBLSPC2;
it worked!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|