say king is our new user.
from scott grant select on emp to king.
from king do
create table emp as select * from scott.emp;
then from scott drop the table emp.
HTH
|
Results 1 to 4 of 4
|
Click Here to Expand Forum to Full Width |