* Rookie - Install Sample Schemas - Oracle 11g - Windows 7

[brunosantana]

Environment information:
* Oracle version: 11g
* Operating system: Windows 7 Professional

I'm trying to install Oracle on the home PC to study for the certification, and certification is based on the example schemes of Oracle (HR, OE, ECT ..) and the installation of them is via dbca, but when I get on the screen to mark the option * example schemes, it is disabled along with Most, if not mistaken only has two options available and the rest is blocked.

I installed and uninstalled, at the time of configuring the bank in dbca I used the user sysdba, I have total administration permission in Windows, I already searched for the download scripts, I checked in the directory " Demo "But LA only has the folders of schemes without any script ... but it has nothing helped me.

Could you help me please?

Thanks,
Bruno Santana
Brunohs_63@hotmail.com

[ishii]

Hello,

Oracle installation is 11gr2? Try complete installation with sample bank.

[] S ISHII

[brunosantana]

I do the most complete installation as possible, but on the screen to signal the * schema examples, this and other options are disabled with a gray appearance.

The version is 11gr2.

Bruno Santana
brunohs_63@hotmail.com

[ishii]

Hello,

Then after you have created the bank (or before) you selected the Manage DBCA models? It should import Oracle_Home \ Assistants \ DBCA \ Templates \ Example.dmp Creating the Bank with Oracle's standard sample data (HR, PM etc)
[] S ISHII

[brunosantana]

So after creating the bank I would access the Manage DBCA models, but the problem persists. It's as if I did not have access, or a limited version or something.

The DBA here of the company said never have seen it.

I just need to check this directory "Oracle_home \ Assistants \ DBCA \ Templates \ Example.dmp" when you get home.

Thanks.

Bruno Santana.
brunohs_63@hotmail.com

[brunosantana]

When I got home I checked that I was accessing the "Configuring a database" option that was where a book indicated me or instead of "managing models", but when I accessed managing models, I did not find the option to import the "example.dmp "That really exists in the" Oracle_Home \ Assistants \ DBCA \ Templates \ Example.dmp ".

I imagined that I could import by Oracle this file, but I still can not find it.

I am still in doubt how to create these example schemes (HR, OE ..), because in DBCA> Configure a database> on the page where some q options selects You want to be installed, such as "sample schemas," the options are disabled in gray color from the rest of the window.

Can you help me?

Thanks.

Bruno Santana.
brunohs_63@hotmail.com

[ecalvetti]

Bruno,

The "Example.dmp" file is an example of transportable tablespace.

You must specify the DataFile of Origin to be imported to the bank.

Run with SYS the MKPLUG.SQL script, to create the Datafile for the Example tablespace. This script will ask you about Datafile, something like "Data_File_Backup". Enter the sample file

Select all

ORACLE_HOME\assistants\dbca\templates\example01.dfb

If the above execution was successfully performed, import the "example.dmp" file, as follows:

Select all

imp transport_tablespace=y file=example.dmp datafiles=' <dir_path>/example01.dfb' tablespaces=EXAMPLE tts_owners=HR,IX,OE,PM,SH...

This should import your Oracle sample schema.
ABS.,

Calvetti
OCA - Oracle Certified Associates
ITIL Foundation