Rockwell Automation RSBizWare Administration Guide - Manual (Page 263)

Database tips Appendix B
In this section you will learn about the following:
• Creating tablespaces (page 263)
• Configuring the database user (page 263)
• Creating a Net Configuration connection (page 264)
• Configuring the Oracle ODBC data source (page 265)
The tablespaces for the RSBizWare installation should contain:
• Data
• Index
• Temp
• Rollback segments
The RSBizWare data model will be loaded into the default
tablespace of the user initializing the database. It is recommended
that you use Oracle Change Management utilities to move indexes
and keys to the index tablespace that you create.
For details, refer to the Oracle documentation.
The database user, who will be the owner of the RSBizWare schema,
should have the privileges for creating:
• Procedures
• Public synonyms
• Sessions
• Sequences
Recommended database
settings
Creating tablespaces
Configuring the database
user
Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 263