Install system support for multiple languages (Asian Languages)

Windows XP

This procedure applies only if you are running a language version of Microsoft Windows XP that doesn't match the language you want to type.

1. On the Windows Start menu, point to Control Panel, and then click Date, Time, Language, and Regional Options.
2. Click the Regional and Language Options icon, and then click the Languages tab.
3. In the Supplemental languages support box, select the check boxes that correspond to the languages you want to use.

Windows 2000

This procedure applies only if you are running a language version of Microsoft Windows 2000 that doesn't match the language you want to type.

1. On the Windows Start menu, point to Settings, and then click Control Panel.
2. Double-click the Regional Options icon, and then click the General tab.

In the Language settings for the system box, select the check boxes next to the languages you want to use.

SQL for altering user schema to add a new tablespace

The following sql is to create a tablespace after creation of a user schema and then alter the user schema to take the new tablespace as default.
It also changes the system defined tablespace 'temp' as the temporary tablespace for the user.

create tablespace pfss datafile '/u12/oradata/wcrsec01/PFSS.dbf' size 100m autoextend on next 50m maxsize 1000m;

create tablespace pfss_idx datafile '/u12/oradata/wcrsec01/PFSS_IDX.dbf' size 100m autoextend on next 50m maxsize 1000m;

alter user pfss default tablespace pfss temporary tablespace temp;

Alter user pfss quota unlimited on pfss_idx;

Alter user pfss quota unlimited on pfss;