This forum is currently locked. You can't register or post questions at this time. (read more)

1Z0-051 hr_main.sql oe_main.sql

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

oeggert2706
Member
Posts: 8
Joined: Mon Nov 16, 2009 9:09 pm

1Z0-051 hr_main.sql oe_main.sql

Postby oeggert2706 » Wed Aug 17, 2011 7:42 am

Hi forum,
I bought McGrawHill "SQL Fundamentals I" and found out that there is a companion cd for the exam questions but no cd
for creating the sample database, sample schemas, ... ! Is this CD downloadable on the ORACLE site ?
Kind regards
oeggert2706

tonis
Senior Member
Posts: 150
Joined: Wed Sep 30, 2009 6:13 pm
Location: Thessaloniki, Greece

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby tonis » Wed Aug 17, 2011 11:59 am

Hi,
Yes, you will have to download the database software from www.oracle.com

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby Tim... » Thu Aug 18, 2011 10:49 pm

Hi.

When you create a database (from the installer or the DBCA), there is an option to include the sample schemas. Check that option an you will be good to go.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

oeggert2706
Member
Posts: 8
Joined: Mon Nov 16, 2009 9:09 pm

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby oeggert2706 » Fri Aug 19, 2011 7:08 pm

Hi,
I just downloaded oracle express edition, but cannot open it. Which program is needed for installation ?
Does anyone know whether the express edition contains these examples schemes ?
Kind regards
Olaf

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby Tim... » Fri Aug 19, 2011 8:28 pm

Hi.

Oracle XE does come with sample schema. See:

http://download.oracle.com/docs/cd/B253 ... 10/toc.htm

Regarding the installation, the downloads are self installing. For Windows it is an exe you run. For Linux it is a package you install. You don't need an additional piece of software to install it.

Read the documenation for installation instructions.

http://www.oracle.com/pls/xe102/portal.all_books

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

oeggert2706
Member
Posts: 8
Joined: Mon Nov 16, 2009 9:09 pm

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby oeggert2706 » Tue Aug 23, 2011 7:32 pm

Hi Tim,
so far I nearly lost one week for nothing. Of course OracleXE is an .exe file but it is downloaded without the .exe ending.
No matter. I installed it in the meantime. But it makes me crazy and angry. the hr schema exists; even hr_main.sql .
But oe_*.sql is desperately wanted. the McGraw Hill book "SQL fundamentals I" talk of a companion cd but it cannot be found
anywhere. And the download from ORACLE homepage does not contain this script. The only thing I want to do is to learn this
book. Where can oe_main.sql and its sub-sql scripts be found ?
Kind regards
oeggert2706

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby Tim... » Tue Aug 23, 2011 7:44 pm

Hi.

The companion CD refers to the full installation of Oracle, not OracleXE.

Oracle XE is a cut down product with loads of stuff missing that is available for free. If they didn't remove a lot of the stuff it would be as massive as the main product. If you want all the other stuff you need to download the full blown product, which you can use for free as part of the limited development license. Oracle Standard Edition (SE) and Enterprise Edition (EE) are very different beasts to XE.

Regarding your "wasted time", be prepared for many more hours of "wasted time". Oracle is not a simple product and even experienced people spend a lot of time reading the manuals to figure things out.

Certification books are good at getting you started, but they are the tip of the iceberg as far as what you need to know to use Oracle effectively.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

oeggert2706
Member
Posts: 8
Joined: Mon Nov 16, 2009 9:09 pm

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby oeggert2706 » Wed Aug 24, 2011 7:54 am

Hi Tim,
of course you are right. I spent 16 years with SAP basis and very often had a look on the ORACLE database, but from the point
of view of a SAP administrator only. In http://download.oracle.com/docs/cd/B105 ... .htm#31399
I hopefully found the scripts' source code I need and am currently making the scripts. If it works this way, okay. If not I'll buy the
personal edition.
Kind regards
Olaf

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 1Z0-051 hr_main.sql oe_main.sql

Postby Tim... » Wed Aug 24, 2011 10:23 am

Hi.

There is no need to buy any Oracle software. All of it can be downloaded from OTN. An OTN download comes with a limited development license, which means you can use it for free for practicing Oracle. As long as you don't do any commercial development, you are not breaking any rules. So you can use Enterprise Edition for free in this context.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 2 guests