6.4.2 Execute the Schema Creator Utility in Online Mode

In Online mode, the utility connects to the database and executes the DDLs for Users, Objects, and Grants. If you have SYSDBA privileges you can execute the Schema Creator Utility in Online mode and thereby create the Users, Objects, and Grants during the execution process. To execute the utility in the Online mode, you must connect as "<User> AS SYSDBA".

To execute the utility in Online mode, follow these steps:

  1. Log in to the system as a non-root user.
  2. Execute the utility with -s option. For Example: ./osc.sh -s

The OFS_PFT_SCHEMA_OUTPUT.xml file is successfully generated. Do not modify this file.