| Schema for Oracle Report Developer 10G Course [message #432951] |
Fri, 27 November 2009 10:29  |
jadeite100
Messages: 5
Registered: May 2009
|
Junior Member |
|
|
Hi All:
I took the course for "Oracle Reports Developer 10g" but I didn't copy the schema when I took the course.
Now,I have the book "Oracle Reports Developer 10g: Build Reports Student Guide" but I look over the internet and I can't find the schema for this course.
I needed the schemas for the following tables:
CUSTOMERS
ORDERS
ORDER_ITEMS
WAREHOUSES
INVENTORIES
PRODUCT_INFORMATION
PRODUCT_DESCRIPTIONS
ONLINE_MEDIA
PRINT_MEDIA
Any help or hint where I can find the sql scripts for this schema is greatly appreciated it.
Yours,
Frustrated.
|
|
|
|
|
|
|
|
| Re: Schema for Oracle Report Developer 10G Course [message #433065 is a reply to message #432951] |
Sun, 29 November 2009 12:28  |
jadeite100
Messages: 5
Registered: May 2009
|
Junior Member |
|
|
Hi LittleFoot:
I installed Oracle for Enterprise Edition for 10 in a vmware and it has the schemas as you described. In the directory as you described:
C:\oracle\product\10.2.0\db_1\demo\schema\order_entry
From oracle web site:
//download-uk.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm
There should be bunch of sql like hr_main.sql, oe_main.sql,pm_main.sql,
There is a bunch of sql but it doesn't have those sql. The reason, I am asking is that in another vmware, I have Oracle 10 but is not the enterprise edition and it doesn't have sample schemas like pm,oe but have hr.
Therefore, I exported the schema like hr,oe,and pm as a dmp file and tried to import into the Oracle database that doesn't have those schemas. But the result is not perfect.
Worst case, I just used the vmware that have Oracle Enterprise database that have those schemas. But just curios what happen to hose hr_main.sql,oe_main.sql,pm_main.sql? Shouldn't they exists?
Yours,
Frustrated.
|
|
|
|
|
|
| Re: Schema for Oracle Report Developer 10G Course [message #433176 is a reply to message #433098] |
Mon, 30 November 2009 09:21 |
jadeite100
Messages: 5
Registered: May 2009
|
Junior Member |
|
|
Hi:
Thanks for replying so soon.
I used imp and exp in Oracle quite a lot before this.
What I did was that I created 4 schemas with the same name as the schema I exported from. I also make sure I used the same tablespace name as the one I exported from used the same tablespace name in the import.
What happen was that the version I exported from is an enterprise version and more later versions of 10g ORacle than the one I imported from. The one I imported from is not an Oracl Enterprise Version and is not as advanced.
So I could some errors about the import didnot recognized some sql commands.
What I am confused is that from ORacle website, in the advanced version of ORacle when I have the hr and oe and pm schemas, I should have the following files in the directory c:\oracle\product\10.2.0\db_1\demo\schema. I found this directory but I didn't see the following files:
hr_main.sql,oe_main.sql,pm_main.sql
Yours,
Albert Lam
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
