Re: Changing table ownership

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 Received on Mon Aug 07 1995 - 00:00:00 CEST