1 2 Previous Next 16 Replies Latest reply: Apr 12, 2011 12:24 PM by 853893 RSS

    SH SCHEMA in oracle XE ?

    853893
      I give up.
      Can anyone tell me is there a possibility to install or simple add SH SCHEMA (with data) to ORACLE XE ?? I want it for data mining tutorial , but I can't install enterprise edition so I am using express edition. I was looking for this some time and can't find anything usefull. I would be very greatfull if anyone can help me. Forgive me my english.
        • 1. Re: SH SCHEMA in oracle XE ?
          Aman....
          A 1 minute Googling gave this,
          http://kareems.wordpress.com/2011/03/20/installing-sh-schema-on-oracle-xe/

          HTH
          Aman....
          • 2. Re: SH SCHEMA in oracle XE ?
            853893
            yes, I found it , this script creates schema, but without data ( I mean - the script has created sch schema, everything was allright, but it didn't generate data in tables) , at least in my case.
            • 3. Re: SH SCHEMA in oracle XE ?
              Rafi (Oracle DBA)
              Hi ,
              Can you check the below link can help you in this:

              http://st-curriculum.oracle.com/obe/jdev/obe1013jdev/common/files/b10771.pdf





              Best regards,

              Rafi.
              http://rafioracledba.blogspot.com/
              • 4. Re: SH SCHEMA in oracle XE ?
                853900
                i have this sql script, but I how to sent to you?
                • 5. Re: SH SCHEMA in oracle XE ?
                  853893
                  user12227954 - Sure, can you send it on my email ? (I'm new here, so I simply past you my adress here, whatever ;) - szymon.86s@gmail.com) .
                  Rafi I'm looking at this curriculum right now. Thanks for answers. I'm looking forward for more.

                  Best Regards,

                  Szymon.

                  ps Rafi I've just found out that I studied this curriculum earlier and it is not concern ORACLE EXPRESS EDITION.

                  Edited by: user13468714 on 2011-04-08 03:09
                  • 6. Re: SH SCHEMA in oracle XE ?
                    853893
                    can anyone else help before this topic death ?
                    • 7. Re: SH SCHEMA in oracle XE ?
                      orafad
                      Give the following a try:

                      * Download the 11.2 Database Examples - link for win32 section as you failed to mention platform (look for win32_11gR2_examples.zip). Note that you need an existing 11.2 home for install, but you might be able to extract script files from staging area.
                      http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

                      * Follow the Sample Schemas document - e.g. note the schemas install ordering if you want the SH schema.
                      http://download.oracle.com/docs/cd/E11882_01/server.112/e10831/toc.htm

                      * Write up a tutorial on this topic while you're at it and share with the community. :)


                      Doc libraries:
                      http://docs.oracle.com/
                      and
                      http://tahiti.oracle.com (search!)


                      For next time:
                      http://forums.oracle.com/forums/category.jspa?categoryID=18
                      Scroll down to find 10g XE forum and 11g XE Beta forum, if that's what you are using.
                      • 8. Re: SH SCHEMA in oracle XE ?
                        orafad
                        A solution is given in the SH SCHEMA in oracle XE for data mining?.
                        • 9. Re: SH SCHEMA in oracle XE ?
                          853893
                          It is not an answer for my question , I'am really frustrated . I just simply want to create sh schema in ORACLE EXPRESS EDITION , future data maning is my problem.
                          Orafad your instructions consider Oracle Database Enterprise/Classic/Standard version - Again - I want to create sh schema ( with data in tables) in ORACLE EXPRESS EDITION. I was able to make sh schema ( thanks to http://kareems.wordpress.com/2011/03/20/installing-sh-schema-on-oracle-xe/) but it didn't fill tables with data. I know i duplicate.
                          • 10. Re: SH SCHEMA in oracle XE ?
                            sb92075
                            http://download.oracle.com/docs/cd/B28359_01/server.111/b28328/scripts.htm#Cihijfgh
                            • 11. Re: SH SCHEMA in oracle XE ?
                              853893
                              Your "reading with understanding" is devasted. It doesn't exist. Thanks for all answers.
                              • 12. Re: SH SCHEMA in oracle XE ?
                                orafad
                                user13468714 wrote:
                                Orafad your instructions consider Oracle Database Enterprise/Classic/Standard version
                                I'm not aware of a XE specific Sample Schema, hence you need to try the existing set of scripts with XE. If something fails perhaps there's a workaround or even ignorable as long as SH gets loaded. It's SQL regardless of Oracle database edition.

                                Did you try the scripts, and failed only in the XE case?
                                • 13. Re: SH SCHEMA in oracle XE ?
                                  orafad
                                  user13468714 wrote:
                                  Your "reading with understanding" is devasted. It doesn't exist. Thanks for all answers.
                                  YOU are asking questions, YOU need to be perfectly explicit about requirements.
                                  • 14. Re: SH SCHEMA in oracle XE ?
                                    853893
                                    XE has predefined only HR user schema. I have installed Enterprise version in another computer and everything was OK - all schemas were created and loaded. I think there is no other option - I need to install somehow and somewhere standard/enterprise edition and try to export all of this from there.
                                    1 2 Previous Next