Home » SQL & PL/SQL » SQL & PL/SQL » Tool for Test data generation and loading (10.2.0.3.0)
Tool for Test data generation and loading [message #403697] Mon, 18 May 2009 02:43 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

Has anyone come across such a tool/asset as mentioned above? Test data is to be generated and loaded in oracle tables. (Around 2 million rows). The table name will be an input so that fields and respective data types are accordingly populated.

Let me know if you need more inputs

Regards,

Re: Tool for Test data generation and loading [message #403698 is a reply to message #403697] Mon, 18 May 2009 02:45 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
./fa/449/0/
Re: Tool for Test data generation and loading [message #403699 is a reply to message #403697] Mon, 18 May 2009 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_random.

Regards
Michel
Re: Tool for Test data generation and loading [message #403701 is a reply to message #403699] Mon, 18 May 2009 03:03 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michel,

can you please explain me clearly ..
Re: Tool for Test data generation and loading [message #403706 is a reply to message #403701] Mon, 18 May 2009 03:24 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
DMBS_RANDOM
Re: Tool for Test data generation and loading [message #403745 is a reply to message #403697] Mon, 18 May 2009 07:33 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
user71408 wrote on Mon, 18 May 2009 13:13
Hi,

Has anyone come across such a tool/asset as mentioned above? Test data is to be generated and loaded in oracle tables.


I remember one of our testing team using DTM Data Generator Tool for creating test data to test one of the database. Google for it. It might help

I didn't understand the rest of your question though.

Regards,
Jo
Re: Tool for Test data generation and loading [message #405800 is a reply to message #403697] Fri, 29 May 2009 09:25 Go to previous messageGo to next message
jess3589
Messages: 1
Registered: May 2009
Junior Member
Have you looked into a tool called Datamaker by Grid-Tools Ltd?

This is probably by far one of the best test data generation products in the marketplace.

Try www.grid-tools.com
Re: Tool for Test data generation and loading [message #405835 is a reply to message #403697] Fri, 29 May 2009 18:51 Go to previous message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
PL/SQL Developer have a Data Generator tool include that you can configure for almost any kind of data. It can also generate data for master detail table. Data can be generate directly in the table or it can generate the SQL file with all insert.
Previous Topic: Namespace attributes in sys context
Next Topic: DDL TRIGGER
Goto Forum:
  


Current Time: Fri Dec 09 17:13:40 CST 2016

Total time taken to generate the page: 0.10973 seconds