Dear Frineds,
I want to change owner of table .Is there any alter command for this.
For exmple:
Suppose I want EMP table to move from scott to any new user.What will be way to do same apart from export/Import.
Regards,
Imti
Printable View
Dear Frineds,
I want to change owner of table .Is there any alter command for this.
For exmple:
Suppose I want EMP table to move from scott to any new user.What will be way to do same apart from export/Import.
Regards,
Imti
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
Thanks Amar,
But in such case we can not get constraints/Indexes only table will be created.
I hope so.
You should ask the whole question, not by parts...
Well in that case, use exp/imp or tools like toad to get the source.
HTH