How to Move Table from one User to another User

[akimtiaz]

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

[adewri]

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

[akimtiaz]

Thanks Amar,
But in such case we can not get constraints/Indexes only table will be created.
I hope so.

[adewri]

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