Oracle® Real-Time Collaboration Administrator's Guide 10g Release 1 (10.1.2) Part Number B25460-03 |
|
|
View PDF |
This appendix provides an overview of the Oracle Real-Time Collaboration database schema accounts and tablespaces. It contains the following sections:
Table D-1 lists the Oracle Real-Time Collaboration schema accounts.
Table D-1 Oracle Real-Time Collaboration Schema Accounts
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.
Table D-2 lists the tablespaces used by the RTC schema account.
Table D-2 Tablespaces for the RTC Schema Account
Table D-3 lists the tablespaces used by the RTC_REP schema account.
Table D-3 Tablespaces for the RTC_REP Schema Account
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.