Chg. Tbl Owner w/o unloading

Posted in 2000

Topics: Migration, Import/Export & Data Conversion

Suresh Voddepalli — Wed, 19 Jan 2000 17:52:33 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, Does anyone know a good and reliable way of changing the table ownership without unloading the data , recreating the table and loading the data back. I know there are some tables like systables, systabnames which have "owner" as a column. But I am not sure of all the tables that may need changing. Thanks, SV

↪ replying to Suresh Voddepalli

Suresh Voddepalli — Wed, 19 Jan 2000 19:10:03 GMT — source: Informix-list mailing list archive (1991-1998)

Suresh Voddepalli wrote: > Hi, > Does anyone know a good and reliable way of changing the table ownership > without unloading the > data , recreating the table and loading the data back. > I know there are some tables like systables, systabnames which have > "owner" as a column. > But I am not sure of all the tables that may need changing. > > Thanks, > SV Never mind. I searched through the deja archives and found that this issue was discussed couple of times last year. Looks like the conclusion was, not to mess with the system tables and instead drop and recreate the tables with the new owner. If anyone has any new ideas pl. post them. Disappointed that INFORMIX doesn't provide some kind of utility to do this..... SureshV.