Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleUse of Tablespaces

Database scripts documented below will create FF, FD and FD_ADMIN schemas with USERS tablespace as default tablespace. You can either change to use different tablespace (update CreateFF.sql, FDOracleCreateSchemaCreateFD.sql) or configure USERS tablespace with appropriate storage configurations. The recommendation is to start with at least 20GB of available space, at least 8GB of RAM and a minimum of 1 or 2 CPUs. Purge settings within FlexDeploy will determine future needs. Normal database backup procedures should be followed.

The AL32UTF8 character set is a good choice.

...

Tip

You must be in /database/oracle/install folder from extracted zip, launch sqlplus(use full path if not available on PATH environment), login as sys or system and then execute the script.

Note - requires running as a user like system or sys with privileges to create users and objects within those schema users

Step 1. Create FlexDeploy schema objects.

  • CreateFlexDeploySchemas.sql <password>
    • password – the password to use for FD, FF, and FD_ADMIN users, which are created by this script.
    • Example: @CreateFlexDeploySchemas.sql welcome1
    • Results are automatically spooled to a file called CreateFlexDeploySchemas.out

...