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
LVL 73

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 76

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 37

Expert Comment

by:Gerwin Jansen
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 73

Expert Comment

ID: 40606707
why the penalty grade?

Author Comment

ID: 40606793
what do you mean?
LVL 73

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 73

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

813 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now