| Tools for automatically filling tables [message #289910] |
Wed, 26 December 2007 09:20  |
ChunCheng
Messages: 2
Registered: December 2007
Location: London
|
Junior Member |
|
|
Hiya,
I am currently testing my new schema design. I would like to know there are tools that help to fill test data into tables automatically. Ideally filling a huge amount of data automatically for performance testing. It would be appreciated if there were any suggestions.
Cheers
ChunCheng
|
|
|
|
| Re: Tools for automatically filling tables [message #289914 is a reply to message #289910] |
Wed, 26 December 2007 09:37  |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
SQL> select dbms_random.value(1,10) "NUMBER", dbms_random.string('A',10) "STRING"
2 from dual
3 connect by level <= 10
4 /
NUMBER STRING
---------- ----------
1.55845116 XrEPiHHant
4.86747382 RfYlgtCNxu
2.18417361 xUBhCzYQuO
3.10267016 IiZlcMXoYF
8.61457287 VrMCzIdRvf
5.13068812 YZGPHXBozB
1.81785275 qQByDibTpP
9.77087452 JXBpgQUvSn
7.44105924 OxgIeBXpdw
2.46703064 WqQkbbThup
10 rows selected.
Regards
Michel
[Updated on: Wed, 26 December 2007 09:38] Report message to a moderator |
|
|
|
| Re: Tools for automatically filling tables [message #289944 is a reply to message #289914] |
Wed, 26 December 2007 16:55 |
ChunCheng
Messages: 2
Registered: December 2007
Location: London
|
Junior Member |
|
|
Hi there,
Thanks for your reply. That's really helpful. However, have you got any idea for any tools that is designed for filling the whole database, I mean not just one table, but also the tables it references.
Thanks again
ChunCheng
|
|
|
|
| Re: Tools for automatically filling tables [message #290786 is a reply to message #289944] |
Mon, 31 December 2007 14:51 |
|
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
No I don't know any such tool and I don't think it exists as filling tables with their relations is too closed of application that a general tool can't exist or is not profitable.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
