wideIT

CREATE DATABASE mynewdb    USER SYS IDENTIFIED BY sys_password    USER SYSTEM IDENTIFIED BY system_password    LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mynewdb/redo01.log') SIZE 100M,            GROUP 2 ('/u01/app/oracle/oradata/mynewdb/redo02.log') SIZE 100M,            GROUP 3 ('/u01/app/oracle/oradata/mynewdb/redo03.log') SIZE 100M    MAXLOGFILES 5    MAXLOGMEMBERS 5    MAXLOGHISTORY 1    MAXDATAFILES 100    CHARACTER SET US7ASCII    NATIONAL CHARACTER SET AL16UTF16    EXTENT MANAGEMENT LOCAL    DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE    SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE    DEFAULT TABLESPACE users       DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'       SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED    DEFAULT TEMPORARY TABLESPACE tempts1       TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'       SIZE 20M REUSE

Concept: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running. A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles). SYNTAX:- CREATE SMALLFILE/BIGFILE TABLESPACE <TSPACE_NAME> DATAFILE '<PHYSICAL_LOCATION\FILE_NAME>' SIZE <FILE_SIZE>[M/K/G/T] AUTOEXTEND ON/OFF {Note: If On}                         NEXT <INCREASE_SIZE>[M/K/G/T ]  MAXSIZE   <FILE_SIZE>[M/K/G/T] LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE

1. double click the oracle 10g installation file. it will check some dependencies. if some files are missing it will let you know. depending on that you have to install some more packages. it is almost certain that you will need libaio1 package. if it is required then just install it from the deb file you just downloaded. if there are no dependencies to be satisfied then install the package. 2. after the installation is finished you need to configure it. for that open the terminal and type Code: Select All /etc/init.d/oracle-xe configure it will ask for some port numbers. just press enter. it will keep the default port. it will also ask for the password. give it and then confirm it. then it will ask to whether to start it at startup or not. I would recommend no. 3. Now you have to add it to the bash. in the terminal type Code: Select All sudo gedit ~/.bashrc at the end of the file add Code: Select All ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2