4

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

Community
  • 1
A T
  • 391
  • 3
  • 8
  • 19
  • 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 00:29
  • 2
    Why do people think it's different just because the database software changes? http://dba.stackexchange.com/questions/4814/ ; http://dba.stackexchange.com/questions/449/ – Joe Oct 31 '11 at 15:55

2 Answers2

3

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

  • Didn't work for me. benefactor.bat 1> log1 2> log2 log1(http://pastebin.com/wk3RKhfj) log2(http://pastebin.com/Em0faE5H) – A T Oct 30 '11 at 23:37
3

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:

Leigh Riffel
  • 23,854
  • 16
  • 78
  • 152