...
TR47_CAWIS_GENERAL_PROPS needs to be backed up before any data refresh and restored afterward
SELECT
'UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_VALUE = ''' ||
PROPERTY_VALUE || ''' WHERE PROPERTY_NAME = ''' ||
PROPERTY_NAME || ''' ; ' AS UPD1
FROM TR47_CAWIS_GENERAL_PROPS ;
PASSWORDS
1)Passwords on all Userids are to be set to “XXXXXX”
...