I need an Oracle test database

Posted on 2014-12-08
Last Modified: 2015-02-13
I don't want to reinvent the wheel.  I just need a megabyte size database for test purposes
Question by:donsql
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 74

Accepted Solution

sdstuber earned 500 total points
ID: 40487177
Download Oracle XE - it can hold up to 11G of data and is quite simple to install and use.

best of all - it's completely free (as in no cost - even for production use)
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40487182
Download Oracle Express Edition:

Then you can include the Sample Schemas.
LVL 19

Expert Comment

ID: 40488280
Have a look at following vids and learn how to install and start with Oracle 11g XE...
How to install Oracle 11g XE on Windows
Introduction to Oracle: Install and Start Using Oracle 11g Express Edition
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40490091
If you're not into installing a database yourself, you could get a pre-built appliance from Oracle for testing purposes, running in Oracle Virtual Box, includes database, sql developer etc:
LVL 74

Expert Comment

ID: 40606707
why the penalty grade?

Author Comment

ID: 40606793
what do you mean?
LVL 74

Expert Comment

ID: 40607751
A "B" is a penalty, an "A" is the expected grade unless you have asked for additional information and either didn't get a response or you received an incomplete or incorrect response.

And, if you award a penalty, you are also expected to explain what was missing and/or wrong.

Author Comment

ID: 40608017
LVL 74

Expert Comment

ID: 40608140
this is still an inappropriate close.

If there are duplicate posts, you should pick the first one.
If multiple posts are close in time to be considered almost simultaneous then a split is ok.

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question