How to Run the Utility

To run the utility:

1. Navigate to the $FIC_HOME/utility/sandboxutil/bin directory and grant RWX (755) permissions for all executables (.sh files).
2. Execute the utility using the following command:
   ./updatesandbox.sh
3. Verify logs from the $FIC_HOME/utility/sandboxutil/logs/Update.log directory.
4. If the process is successful, verify the following references for new constraint names:
   ftpshare/<SANDBOXINFODOM>/erwin/scripts/sandbox/CONSTRAINTS.xml

   ftpshare/<SANDBOXINFODOM>/erwin/scripts/sandbox/<TABLE_NAME>.xml

5. In case of failure, refer the utility's log and restore the backups for the file system.
6. Execute the utility for the failed infodoms one by one using the following command:
   $FIC_HOME/utility/sandboxutil/bin/updatesandbox.sh $INFODOM.

   Note:

   The utility does the backup of ftpshare/<SANDBOXINFODOM>/erwin/scripts/sandbox directory as ftpshare/<SANDBOXINFODOM>/erwin/scripts/sandbox_bkp, but restore is not done. Restore must be done manually in case of any failure. The backup directory will be created in the app ftpshare area. In case of any failure, the backup has to be replaced in the database ftpshare area also.

   For queries, contact My Oracle Support.