当前位置: 动力学知识库 > 问答 > 编程问答 >

Is there a good alternative to local Oracle 11g XE to mimic Oracle in Prod?

问题描述:

We use Oracle in our Prod environment with a lot of MVs where we pull in data from other systems to create our schema to query.

Locally we develop against Oracle 11g XE. We just download the corresponding MV tables to our local version. Two of these tables have over 3 million records. Once we get done applying all the indexes our users.dbf file and TableSpace exceeds the Oracle 11g XE 11 gig limit.

I'm sure a lot of people run into this. Is there an alternative database that could mimic the Prod full version of Oracle 11g for us as a local Oracle development database?

网友答案:

You can create a Free "as in beer" OTN Account at http://www.oracle.com - you can also use and install any Oracle Edition for development for Free "as in beer", again. :)

Here are the links: Oracle Database Download Landing Page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Accept their license agreement, Select the appropriate OS and click on Select all (when you arrive at the appropriate OS Landing page). Again, accept their agreement (I know, it's not intuitive).

Here's a snippet of their license agreement: Oracle grants You a nonexclusive, nontransferable, limited license to internally use the Programs, subject to the restrictions stated in this Agreement, only for the purpose of developing, testing, prototyping, and demonstrating Your application and only as long as Your application has not been used for any data processing, business, commercial, or production purposes, and not for any other purpose.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Hope it helps!

分享给朋友:
您可能感兴趣的文章:
随机阅读: