D Oracle Real-Time Collaboration Database Accounts and Tablespaces

This appendix provides an overview of the Oracle Real-Time Collaboration database schema accounts and tablespaces. It contains the following sections:

Oracle Real-Time Collaboration Database Schema Accounts
Oracle Real-Time Collaboration Tablespace Accounts

Oracle Real-Time Collaboration Database Schema Accounts

Table D-1 lists the Oracle Real-Time Collaboration schema accounts.

Table D-1 Oracle Real-Time Collaboration Schema Accounts

Account Name	Content
RTC	All the tables and objects considered business data, including lookup and transaction database objects (tables, indexes, views, sequences, stored procedures and packages, and triggers) of the schema.
RTC_APP	The synonyms that refer to tables, views, and sequences in the RTC and RTC_REP accounts. This account has appropriate read/write access to the tables in the RTC and RTC_REP schemas.
RTC_IM	All the database objects for Oracle Messenger, including presence, statistics, messages, chat rooms, and so forth.
RTC_REP	All the database objects that deal with transient and reporting data for Oracle Real-Time Collaboration. This data is primarily used for reporting purposes and could either be calculated by transaction data from the RTC account, or used for monitoring.

Deleting User Data From the Oracle Real-Time Collaboration Database

If you want to reclaim disk space occupied by users who were deleted from the Oracle Internet Directory, you can optionally delete old users and their associated data from the Oracle Real-Time Collaboration repository using the delete_user.pl perl script located in the $ORACLE_HOME/imeeting/install/db directory. This script only deletes users who have already been deleted from the Oracle Internet Directory.

Warning:

Use this script with extreme caution. All archived conferences and message archives associated with the deleted users will be permanently deleted and cannot be recovered.

The delete_user.pl perl script is used as follows:

delete_user.pl -dbname dbname -rtc_app_user RTC_APP_DB_USER -rtc_app_password RTC_APP_PASSWD [-user username]

where:

dbname is the alias string taken from the $ORACLE_HOME/network/admin/tnsnames.ora file.
RTC_APP_DB_USER is the name of the RTC_APP schema account.
RTC_APP_PASSWD is the password for the RTC_APP schema account.
[-user username] is optional and specifies the complete username of a specific user that you want to delete. The user's archived conferences and message archives will be permanently deleted. If this argument is not specified, all user data, including all archived conferences and message archives, will be permanently deleted for users who were deleted from the Oracle Internet Directory. Once deleted, this data cannot be recovered.

Oracle Real-Time Collaboration Tablespace Accounts

Table D-2 lists the tablespaces used by the RTC schema account.

Table D-2 Tablespaces for the RTC Schema Account

Tablespace	Content
RTC_ARCHIVE_DATA	Tables of archive and history data, such as history of conference documents, conference modes, chat history, and so forth.
RTC_ARCHIVE_INDEX	Indexes for RTC_ARCHIVE_DATA.
RTC_DOCUMENT_DATA	Tables used by the document management module, mostly partitioned, containing stored documents, polls, bookmarks, and messages. May contain large amounts of data.
RTC_DOCUMENT_INDEX	Indexes for RTC_DOCUMENT_DATA.
RTC_IM_DATA	Tables used by the Oracle Messenger module. May contain large amounts of data.
RTC_IM_INDEX	Indexes for RTC_IM_DATA.
RTC_LOOKUP_DATA	Tables that contain lookup and nontransactional data, such as administration properties, configuration components, menu rendering data, and so forth.
RTC_LOOKUP_INDEX	Indexes for RTC_LOOKUP_DATA.
RTC_RECORDING_DATA	Tables used by the recording management module, mostly partitioned, containing recordings. May contain large amounts of data.
RTC_RECORDING_INDEX	Indexes for RTC_RECORDING_DATA.
RTC_TRANSACTION_DATA	Tables of transaction data, mostly partitioned, regarding conferences, attendees, polls, and so forth. May contain large amounts of data.
RTC_TRANSACTION_INDEX	Indexes for RTC_TRANSACTION_DATA.

Table D-3 lists the tablespaces used by the RTC_REP schema account.

Table D-3 Tablespaces for the RTC_REP Schema Account

Tablespace	Content
RTC_TRANSIENT_DATA	Tables containing transient data used by real-time monitoring of the Oracle Real-Time Collaboration server process.
RTC_TRANSIENT_INDEX	Indexes for RTC_TRANSIENT_DATA.
RTC_TRANSIENT_LOB_DATA	Tables containing transient data for lines of business (sites), used by incident management and logging.
RTC_TRANSIENT_LOB_INDEX	Indexes for RTC_TRANSIENT_LOB_DATA.
RTC_REPORT_DATA	Materialized views aggregated on a daily, weekly, or monthly basis and used for reporting.
RTC_REPORT_INDEX	Indexes for RTC_REPORT_DATA.

There are no tablespaces for the RTC_APP account.

An additional tablespace, RTC_TEMP, is used by all Oracle Real-Time Collaboration schema accounts to hold temporary data.