Forum Stats

  • 3,770,050 Users
  • 2,253,054 Discussions
  • 7,875,283 Comments

Discussions

Steps to enable the SH schema while Installing Oracle 11gR2 database

884336
884336 Member Posts: 15
edited Sep 14, 2012 8:25AM in Database Installation
Hi,

How to enable the Sales History schema along with Oracle 11g Installation in the Windows 7 Operating system?

System Specification,

Operating System - Windows 7 64 Bit version home basic
Database - Oracle 11g Release 2 Express Edition 64 bit version

Many thanks in advance.

Regards,
Murali

Edited by: 881333 on Sep 13, 2012 7:42 AM

Edited by: 881333 on Sep 13, 2012 7:45 AM
Tagged:

Answers

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    881333 wrote:
    Hi,

    How to enable the Sales History schema along with Oracle 11g Installation in the Windows 7 Operating system?

    System Specification,

    Operating System - Windows 7 64 Bit version home basic
    Database - Oracle 11g Release 2 Express Edition 64 bit version

    Many thanks in advance.

    Regards,
    Murali

    Edited by: 881333 on Sep 13, 2012 7:42 AM

    Edited by: 881333 on Sep 13, 2012 7:45 AM
    http://www.lmgtfy.com/?q=oracle+sales+history+schema+download
  • Srini Chavali-Oracle
    Srini Chavali-Oracle Member Posts: 29,596 Blue Diamond
    881333 wrote:
    Hi,

    How to enable the Sales History schema along with Oracle 11g Installation in the Windows 7 Operating system?
    http://docs.oracle.com/cd/E11882_01/server.112/e10831/installation.htm#COMSC00008
    System Specification,

    Operating System - Windows 7 64 Bit version home basic
    Database - Oracle 11g Release 2 Express Edition 64 bit version
    Pl be aware that no Oracle database version is certified on Home versions of Windows. Also, there is no Win 64 bit version of XE.

    http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABGGAJA
    Many thanks in advance.

    Regards,
    Murali

    Edited by: 881333 on Sep 13, 2012 7:42 AM

    Edited by: 881333 on Sep 13, 2012 7:45 AM
    HTH
    Srini
  • orafad
    orafad Member Posts: 8,035 Silver Trophy
    881333 wrote:
    Hi,

    How to enable the Sales History schema along with Oracle 11g Installation in the Windows 7 Operating system?
    This is part of Sample Schemas, and is well documented. Search docu library for sample schemas and also read the specific Sample schemas document:
    http://docs.oracle.com/cd/E11882_01/server.112/e10831/overview.htm

    If you don't use dbca and create a database from a pre-seeded database, then you go the manual route so the Database Examples installation media/pack provides the required scripts, etc.


    >
    Operating System - Windows 7 64 Bit version home basic
    Database - Oracle 11g Release 2 Express Edition 64 bit version
    This case might not be the best for a couple of reasons, also mentioned above
    - a x64 release of XE is yet to be seen
    - you do not have dbca in XE, so roll up your sleeves...
    - SH builds on components or features not available with XE
    - there's a given order per doc, you may need to install other schemas before SH


    This thread details an attempt to install (not the full) SH schema in XE:
    2206625
  • 884336
    884336 Member Posts: 15
    Hi,

    Thanks for your response.

    Any changes need to be made to install the Sample schema while installing the Oracle 11g database ?

    Regards,
    Murali
  • Srini Chavali-Oracle
    Srini Chavali-Oracle Member Posts: 29,596 Blue Diamond
    edited Sep 14, 2012 8:25AM
    Pl clarify exactly what software you are installing - there is no 64-bit Windows version of 11g XE.

    No special requirements are needed to install the sample schemas - pl follow the instruction in the link posted above.

    HTH
    Srini
This discussion has been closed.