Install

• Oracle Database 10g Express Edition
• Oracle Client 10g Express Edition

Create a Tablespace on XE

Create a temp table space, system tables space, a user, and grant right to user.

Note: tablespace names cannot begin with a digit.

Windows Commands:

create temporary tablespace idc_temp tempfile 'C:\oraclexe\oradata\XE\idc_temp.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

create tablespace idc_sys datafile 'C:\oraclexe\oradata\XE\idc_sys.dbf' size 200M reuse autoextend on next 5120k maxsize unlimited;

create USER idc_user IDENTIFIED by idc_user temporary tablespace idc_temp default tablespace idc_sys quota unlimited on idc_sys;

grant connect, resource to idc_user;

Unix Commands:

create temporary tablespace idc_temp tempfile '/u01/app/oracle/oradata/ucm1/idc_temp.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
create tablespace idc_sys datafile '/u01/app/oracle/oradata/ucm1/idc_sys.dbf' size 200M reuse autoextend on next 5120k maxsize unlimited;
create USER idc_user IDENTIFIED by idc_user temporary tablespace idc_temp default tablespace idc_sys quota unlimited on idc_sys;

grant connect, resource to idc_user;

Remove Tablespace:
drop tablespace idc_temp including contents and datafiles;
drop tablespace idc_sys including contents and datafiles;
drop user idc_user;

SQL Plus Connection

Method 1

at the prompt, first connect to a database: connect <username>/<password> eg connect system/manager

Method 2

In a dos window type: c:> sqlplus /nolog That will open sqlplus and when you are in sqlplus type: SQL> connect / as sysdba If the db is no started type: startup pfile=C:\oraclexe\app\oracle\admin\oraXE\pfile\initoraXE.ora

Show all tables

select * from user_objects where object_type = 'table'; Allow multiple SCS connect to DB

1. Log into the Oracle XE web interface as SYS and go to SQL ->SQL Commands ->Enter SQL Command
2. Enter the following command and click Run:

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE

1. Restart the Oracle XE Service

Service dependencies

Once you've installed CS, it is useful to make the CS service dependent on both your HTTP Server and Database Server services. To do this, open a command prompt and execute commands:
In the above, note that:
The service names are not the "display names" used in the main Windows services view. Instead, they are the actual service name, which you can see by right-clicking on a service, selecting "Properties" and viewing the "Service name" property on the "General" tab.
The space between depend= and the list of service names is required.