Skip to Main Content
Forums

E-Business Suite

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Business Intelligence for ebusiness suite 11i

237207Aug 16 2006 — edited Mar 6 2007
Hi, all
I am considering to implemete business intelligence for our current ebusiness suite 11.5.10.2. Right now, we conside to create a seperate data warehouse system with current production because we have so many discoverer reports(we use discoverer's Ebusiness suite package to create EUL) and some of them have performace impact to production. I will use DBI as some of prebuild reports and discoverer+DW for customized reports. So my question is:
1. Does anybody implement data warehouse system using ebusiness suite as data source? I heard new OWB 2.0 have improvement on ebusiness suite connector. Can you share some experience here?
2. Can DBI schema be data source for data warehouse?

Comments

unknown-698157
Answer
No. Partitioning is an extra cost option in Enterprise Edition.

--------------
Sybrand Bakker
Senior Oracle DBA
Marked as Answer by 692707 · Sep 27 2020
Aman....
You need to ahve EE edition to use it,
http://www.oracle.com/database/product_editions.html

HTH
Aman....
1 person found this helpful
692707
Are there any alternatives for that..?

How should we import the tables created with partition in enterprise edition into a standard edition...???
Satish Kandi
Assuming your source and target oracle versions are the same, try pre-creating the table on target database as regular table and import with ignore=y.
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 3 2007
Added on Aug 16 2006
#business-intelligence-ebs
11 comments
2,199 views