3 Replies Latest reply: Jul 20, 2012 2:03 PM by Srini Chavali-Oracle RSS

    Enterprise edition demos on Express Edition

    950808
      Just put Express Edition on download. Was wondering if I will be able to access the 10G/11G enterprise edition demo tables. Such as the legendary "SCOTT" schema. Please enlighten me.

      If they don't come in with Express Edition then how can I make them work manually.

      Thanks in advance.
        • 1. Re: Enterprise edition demos on Express Edition
          sb92075
          947805 wrote:
          Just put Express Edition on download. Was wondering if I will be able to access the 10G/11G enterprise edition demo tables. Such as the legendary "SCOTT" schema. Please enlighten me.

          If they don't come in with Express Edition then how can I make them work manually.
          manually load & create the desired obects
          • 2. Re: Enterprise edition demos on Express Edition
            jgarry
            There is a sample download on http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

            I haven't tried it, I'm assuming it is the hr stuff.

            If you want the old scott schema, find the files mentioned in http://www.orafaq.com/wiki/SCOTT I think I've seen them online somewhere, but don't have time to look just now.

            Edit: Just tried hr in my express, and it is there but locked. So you may simply have to unlock the accounts, which I believe is in some docs somewhere.

            Edited by: jgarry on Jul 20, 2012 9:30 AM
            • 3. Re: Enterprise edition demos on Express Edition
              Srini Chavali-Oracle
              These links may help

              http://docs.oracle.com/cd/E11882_01/install.112/e24501/toc.htm

              http://docs.oracle.com/cd/E11882_01/server.112/e10831/toc.htm

              Some of these examples may require features not available in XE - http://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm#BABJBGGA

              HTH
              Srini