2011

See also:
■ Overview of Geospatial Data (page 551)
■ Setting Up Database Users (page 584)
■ Creating a Data Store (page 586)
■ Bringing In Features from Oracle (page 312)
■ Creating a Join (page 509)
■ Editing Features using the Data Table (page 711)
■ Creating a Schema (page 596)
■ Viewing a Schema (page 608)
■ Editing a Schema (page 610)
■ Migrating Data (page 615)
To enable versioning for an Oracle data store
1 You enable versioning with the Oracle SQL*Plus tool, which you use to
execute the scripts. Before executing the scripts, make sure that the
following conditions are true:
■ You connect directly to the Oracle user (or FDO data store) to be
processed.
■ The Oracle user executing the script has sufficient privileges (has been
granted the Workspace Manager role WM_ADMIN_ROLE).
■ The Oracle user executing the script is the only user processing or
accessing the current Oracle user (or FDO data store) during the
execution of the script. Otherwise, a script failure may result from a
session conflict.
2 To create a script log file, execute the spool <log file name>; command
before invoking the scripts and the spool off; command after the
invoked script finishes. The log file can help you resolve any issues
encountered by the scripts.
3 Read the documentation contained within the script files themselves to
determine what privileges are required for each script, how to run the
scripts, and what errors may occur.
Working with Oracle Data | 557