Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing sample schemas

f7686677-fb0a-4969-aff1-8196462f398eSep 25 2017 — edited Sep 25 2017

Hi Guys,

I have been trying to install sample schemas in my Oracle 12C, but I can't find .sql files in the following directory: product\12.2.0\dbhome_1\demo\schema. So I cannot perform the proper installation. I downloaded and installed Oracle Database Examples, setting the proper paths for both Oracle Base, and Oracle Home but still i don't have .sql files for schemas. The only one that existsts in my database is HR schema, which I have already unlocked, but I still need rest of them for the training purposes. I have been searching for resolution on the internet for the past few days, but I didn't find the working one.

According to this guideline (  Installing Sample Schemas. ) I cannot  successfully perform anything besides the HR-related commands. Can you please tell me how can I get these files? To be clear I need to get: oe_main.sql, pm_main.sql, ix_main.sql, sh.main sql.

Thank you in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2017
Added on Sep 25 2017
1 comment
745 views