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.
Hope it helps!