Informix/PeopleSoft Question.

Posted in 1998

Abhay Mannur — Tue, 03 Mar 1998 08:55:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi All, Environment : Informix 7.22 and 7.23 PeopleSoft 7.0 Whenever we want to change a DB owner, we export the database and edit the schema file (dbname.sql) After importing again, we change 3 PeopleSoft specific tables : psdbowner, pslock and psoperdefn out of which the first table is ownd by PS and the other two are owned by dbowner of the database. Is there any way to do this without export/import which is time consuming. Can I update system catalog tables to do this and is this advisable ? Thanks in advance. Abhay.