Step 2 Run the Project Schema Script (as BE_USER)

In this step, you log on as the user you created and run a script to create the project related part of the database schema.

Procedure

  • Open a command window in BE_HOME/bin and run the yourname.sql script. (for example, @acme.sql). Use the user BE_USER, password BE_USER (or whatever username and password you have set up).
    • For Oracle:
      sqlplus BE_USER/BE_USER @ yourname.sql
    • For SQL Server:
      osql -S Your-Server –d Your-DB -U BE_USER -P BE_USER -n -i @yourname.sql
    • For MySQL:
      mysql -u BE_USER -p database_name < yourname.sql
    • For Postgresql:
      use database_name
      psql -u username -f yourname.sql

Result

If there are no errors, your database tables are now configured for use. If there are errors you may need to add some mappings to the key word mapping file.