Re: Changing table ownership

Michel Lapierre (milapier_at_ge.hydro.qc.hq) wrote:
> kristoff_at_baseware.com wrote-écrivait:
 

> >Hi Everyone!
 

> >Is it possible to change ownership of a table in Oracle 7?
 

> >Thanks,
> >Eric

> No, the only way is to duplicate your table with
 

> create table newowner.tablename as select * from
> oldowner.tablename
 

> drop table oldowner.tablename
 

> or you can use export and import (fromuser / touser option)
 

> Michel Lapierre

If you use the 'create as select', then don't forget to manually re-create the indexes, constraints, triggers, etc.

Much easier to export/import

/Hans Received on Mon Aug 07 1995 - 00:00:00 CEST