Re: change the owner of table

> hi, guys:
>
> I want change some table's owner, how can I do that? thanks.

Hi,
export/import - the most convenient in such a case I think. (see FROMUSER, TOUSER clauses).
Besides you can use "create table as select" statement and recreate indexes, constraints etc manually then.
The method to prefer depends on your specific situation.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com