Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Good morning,

What free [or trial] software can I use to generate sample data for an Oracle database?

I've been trying with various tools, but none work.

Thanks for all suggestions,

Alec Taylor

share|improve this question

closed as not constructive by Gaius, dezso, Mark Storey-Smith, ypercube, Max Vernon May 16 '13 at 18:10

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

3  
If you could expand on the tools you've tried and examples of where they failed, you're likely to get much more useful answers. –  Mark Storey-Smith Oct 31 '11 at 0:29
2  
Why do people think it's different just because the database software changes? dba.stackexchange.com/questions/4814 ; dba.stackexchange.com/questions/449 –  Joe Oct 31 '11 at 15:55

2 Answers 2

I like Benerator. It's not super easy to setup but quite flexible.

share|improve this answer
    
Didn't work for me. benefactor.bat 1> log1 2> log2 log1(pastebin.com/wk3RKhfj) log2(pastebin.com/Em0faE5H) –  A T Oct 30 '11 at 23:37

Oracle includes scripts to create several sample schema and data. Oracle has a whole book (54 pages) discussing the scripts and schema created. If you want to generate data for your own schema then you should look at things like these:

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.