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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle DR - data guard failover. 18 73
Oracle Date 6 39
Oracle Partitions. 1 18
Oracle Date add 9 31
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…
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

737 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