5.1.3 Selecting Execution Modes in Schema Creator Utility

Schema creator utility supports the following mode of execution:

• Offline Mode: In this mode, the utility generates an SQL script with all the required DDLs for User, Entities and GRANTS. This script must be executed by the DBA on the appropriate database identified for OFSAA usage.

  Note:

  For running the SQL script generated in offline mode, the script should reside in the same directory where the 'SQLScripts' directory is available.

  Note:

  Connect as any database user.

  Reconfigure the OFS_SANC_SCHEMA_IN.xml and execute the utility. For more information on reconfiguring these files, see Configuring OFS_SANC_SCHEMA_IN.xml file .

  To execute the utility in Offline mode, you must connect as a user with the following GRANTS (alternatively, you can also connect as a user with SYSDBA privileges):

  SELECT ON DBA_ROLES

  SELECT ON DBA_USERS

  SELECT ON DBA_DIRECTORIES

  SELECT ON DBA_TABLESPACES

  CREATE SESSION

  If there are any errors during the SQL script execution, reconfigure the OFS_SANC_SCHEMA_IN.xml and execute the utility. This regenerates the scripts with corrected information.

  For more information, see Configuring OFS_SANC_SCHEMA_IN.xml file .

  Note:

  Do not modify the OFS_SANC_SCHEMA_OUT.XML file generated after the execution of this utility

  If there are any errors during the SQL script execution, reconfigure the OFS_SANC_SCHEMA_IN.xml file and execute the utility. This regenerates the scripts with corrected information. See Configuring OFS_SANC_SCHEMA_IN.xml file .

  Do not keep any backup files of xml's in the download directory.