Oracle XE database directory

The Database Data are placed in the directory you choose for this.
It is pointed by ORACLE_BASE environment variable.
The software is placed in ORACLE_HOME directory.
You have to choose it also.

So an example is:
ORACLE_HOME in c:\oraclehome\
ORACLE_BASE in c:\oraclebase\

Sorry, I'm not familiar with oracle configuration file , can you guide , which file do i have to edit . I'm mysql user . I can see c:\mysql\data all database user and mysql.cnf is place for changing setting of database data.

These parameters in Windows are created automatically and can be seen in the Registry, in the Oracle section.

MySQL is a simple DB. Oracle is corporate product.
To see the users you have to remember the password of the "root" SYS user. You have to find the tnsnames.ora file and to see the alias of the connection string (it is the SID name you gave the DB!!!)

Invoke SQL*Plus (either from Start menu or from ..../bin file)

SQL>connect sys/password@alias as sysdba

To see the users:

SQL>descr dba_users    --- show the structure of this view
SQL> select username from dba_users;  --- to see all user names

SQL>create user myuser identified by myuserpass; --- cerates a new user
SQL>connect myuser/myuserpass@alias    -- connects as the new user

thank you anand_2000v and schwertner,

so I must change registry to force oracle to save file into d:\oracle for example ?

is there any other way to do it ?

thanks

may i know which files you are mentioning about ?

MySQL has my.ini file

#This File was made using the WinMySQLAdmin 1.3 Tool

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions


[mysqld]
skip-locking
skip-innodb
set-variable    = max_connections=16384
default-character-set=latin1
basedir=C:\AppServ/mysql
#bind-address=
datadir=C:\AppServ/mysql/data
#language=C:/AppServ/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[client]
default-character-set=latin1
[WinMySQLadmin]
user=mysql
password=mysql

datadir=C:\AppServ/mysql/data ==> place for all database file create by user

change to D:\mydata , restart mysql

I see, maybe I must install dedicated server for our student .

thank very much  for all reply

Yes, dedicated Oracle server for the students.
Create user for every student.

First create a tablespace for all students:

CREATE TABLESPACE students DATAFILE
  c:\....\students.dbf' SIZE 25M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

For every students (xxxx is ID):

CREATE USER stxxxx
  IDENTIFIED BY stxxxx
  DEFAULT TABLESPACE students;
 
  GRANT UNLIMITED TABLESPACE TO stxxxx;
  -- 1 Tablespace Quota for AUTHR
  ALTER USER stxxxx QUOTA UNLIMITED ON students;

GRANT create procedure, create session,create table,create type,create view,create synonym TO stxxxx;

Do this for every student.

I do the same for our students :)

Oracle has also init file - init....ora
But mainly it uses SPFILE.ora - but never change it by editor because the installation will colapse!!!!!!!!!!!!!!

thanks schwertner,

very helpfull

if you don't mind would you share your server environment

we use freebsd 6.1 ,1GB memory, PIV 3.0G in Pre Entry Intel Board to  serve mysql and postgresql for appoximately 1000 student

I'm still study install process in freebsd since many tutorial use linux or windows :-(

Initially we tried to install Oracle on a small Sun server machine, but failed to do this, because
we hadn't enough space for the swap partition.
So were forced to install Oracle on Windows XP machine with 2 GB RAM and over 120 GB HDD.