After a long time, I’m working with oracle database. I need setup oracle server installed on development server. Installation is not much complicated . Download the rpm respect to your OS distros and run ” /etc/init.d/oracle-xe configure” after the installs.
There few things you may concern while installing OracleXE.
1. Choose the Custom port for managing web administration.
2. It does support only 4GB user data storage and we can’t change the oracle data path. It should be in /usr/lib/oracle/xe/app/oracle.
3. You need to setup Oracle environmental variables (ORACLE_HOME and ORACLE_SID) I placed a file oracl.sh in “/etc/profile.d/”
/etc/profile.d/oracl.sh have the following contents
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server; export ORACLE_HOME
ORACLE_SID=XE; export ORACLE_SID
PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin; export PATH
Once you have completed installation, you may either use Web UI or commandline to administrate the database. In Oracle there is no multiple database concept as we are working with MySQl or Postgresql. There is a single database (in EX) and the term “tablespace” is equivalent to the “database” concept. So we need to create tablespace for each projects. tables space is just allocating reserved space for all the tables created in that area.
Login to oracle sql prompt
You may need to add the oracle binary path in system path. Execute it from the terminal.
Type sqlplus from the terminal
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 25 10:34:28 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
1. Creating tablespace for a user
Here autoextend will allow to extend the tablespace when it over 100MB which is a recommended method in production mode.
1. How do I create a new user
3. Grant limited access to that user
4. How do I view all the privileged tables I created.
5. Backup: Export the dump owned by the user ‘admin’
6. Export all the databases
7. If you want to backup only specific tables
8. Import the tables owned by the user admin to a new user ‘temple’
9. Import all the database to a new server
10. To import few tables from the backup schema
11. How do extend the user quota when it reaches the limit