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

884336

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

sb92075

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

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

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

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

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