-In order to install RT with Oracle, the database must first be
-prepared. Ports of RT to other databases will automatically create
-the RT schema. This is not done for Oracle because most sites wishing
-to deploy RT on Oracle will have choose to make specific configuration
-of the RT user, for example to select the appropriate tablespace or to
-set up a resource profile. The RT user must have appropriate
-privileges similar to the resource and connect roles and must have the
-"query rewrite" system privilege.
- Here is an example of commands to create an RT user called "RT" with
-a password of "rt".
-
- create user rt identified by rt default tablespace users temporary
- tablespace temp;
- grant resource, connect, query rewrite to rt;
-
-
-RT should not run its schema creation as the Oracle DBA; instead the
-schema creation should be run as the RT user. To accomplish this set
-the --with-rt-dba configuration parameter to the RT user, not to the
-Oracle DBA. As an example, the following might be appropriate to
-configure RT for the example.com Oracle database.
-
- ./configure --prefix /usr/local/rt --with-db-type=Oracle \
- --with-db-dba=rt --with-db-database=example.com \
- --with-db-rt-user=rt \
- --with-db-rt-pass=rt
-
-
-As with all databases it is important to analyze the Schema and get
-current statistics after any significant dataset change. Oracle's
+On RT 3.8.2 and later, RT deployment for Oracle databases is very
+straightforward.
+
+You don't need to configure Oracle beforehand. During installation
+a user is created and all RT's objects are created in his schema.
+The user is created with the following parameters:
+
+ CREATE USER <DatabaseUser> IDENTIFIED BY <DatabasePassword>
+ DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
+ QUOTA UNLIMITED ON USERS
+
+And the user is also granted 'CONNECT' and 'RESOURCE'. It's up to you
+to do decide how to manage users, change quotas, table spaces, etc.
+
+RT has an option $DatabaseName which is used to define the SID of
+the Oracle database. You don't have to set up the TWO_TASK environment
+variable or any helper files for establishing connections.
+
+Example:
+
+ ./configure \
+ --with-db-type=Oracle \
+ --with-db-database=XE \
+ --with-db-host=192.168.0.1 \
+ --with-db-dba=system \
+ --with-db-rt-user=rtdb1 \
+ --with-db-rt-pass=rtdb1secret \
+ ... other configure options ...
+
+That should be enough to get you started on Oracle, but to complete
+installation you must follow the general instructions in the README file.
+
+As with all databases it is important to analyze the schema and get
+current statistics after every significant dataset change. Oracle's