Table Owner Rename
Posted in 2000
Topics: Server Administration, Migration, Import/Export & Data Conversion
I'd like to rename the owner part of a table. I had a table "dba.tablename" that was being referenced by a bunch of reports. I ran a job as user "informix", which unloaded all the data, dropped the table and then recreated it and reloaded it. Obviously, the table's name is now "informix.tablename". The rename command does not affect the owner part of the table. Informix tells me that I can only rename the owner part of the table by performing the same process I performed above. Is there a quicker way to rename such table? Will making changes to the systables' owner column of that table cause damage? Thanks.
>Is there a quicker way to rename such table? No, you have to drop and recreate. >Will making changes to the systables' owner column of that table cause >damage? Yes, it's not the only place that the owner name is stored. --Chuck