Home
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software
Latest
Popular
Who's Online
We have 119 guests online

Installing sample schema in Oracle 10g R2 Print E-mail
Installing sample schemas(HR,OE,PM etc...) in Oracle 10g R2

1. Get the companion disk for Oracle 10g from oracle.com

2. Unzip and extract the contents on the server

3. Run the Oracle Universal Installer to install the components, choose "Oracle database products"
4. After successfull install,login in the database with SYSDBA privs and run the sample schema scripts located here $ORACLE_HOME/demo/schema

5. To continue ahead , refer to this link
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm

6. During the installation of the sample schema, it would prompt for some questions such as for locations of directory for log etc.
    a. Mention the directories on which the Oracle software Owner has write permissions, prefer $ORACLE_HOME
    b. version (turned out to be 'v3' for Oracle 10gr2, refer to the script for this in the sql_script, the script will be available as 'prefix_v3.sql')
< Previous   Next >



Polls
Have you visited this site earlier?
  
gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org