Database Import Generate Data

Toad for Oracle - Beta
1

Good Afternoon TOAD Team,

I’ve never used this feature (Database / Import / Generate Data), so it is likely the nut behind the keyboard; but I cannot figure out how to use the function. I’d like to create some fabricated data to slow operations down a little for tuning. I have not found instructions online. Please help…

2

Hey Larry,

There is a little “+” icon down at the bottom of the window that you probably aren’t seeing. This is used to add a table to the generate table window.

The easiest way to generate data for just one table is:

  1. Go to schema browser. RIght-click your table and choose Data -> Generate (or just right-click -> Generate Data for 12.11 and prior).

  2. Optional - click on the table to adjust table settings. Click on the columns to adjust column settings.

  3. click the Green triangle at the top to run it.

3

Hey Larry,

There is a little “+” icon down at the bottom of the window that I think you aren’t seeing. You can click the “+” to add tables to the window, but I think it’s easier to do it this way, especially if only one table is involved:

  1. Go to schema browser. RIght-click your table and choose Data -> Generate (If you have Toad 12.11 or prior, it’s right-click -> Generate Data).

  2. Optional - click on the table to adjust table settings. Click on the columns to adjust column settings.

  3. Click the Green triangle at the top to run it.

4

Hey Larry,

In addition to John’s post, there’s also a couple blogs on Toad World which may help:

https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2015/03/11/how-to-generate-realistic-datasets-with-toad-for-oracle-xpert-edition

https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2012/12/12/how-to-enforce-referential-integrity-when-using-the-toad-for-oracle-data-generation-feature

On the “General Options” page, you have the option of specifying which data engine to use. You can find information about each engine in Toad’s help.

  • The “Internal” engine is always available and provides the most flexibility without installing anything to the database; however it will be the slowest as it creates “n” INSERT statements (one for each row being created). If you’re working with small data sets, this is the easiest; however, if you need to create thousands of records across multiple tables, this method could be fairly slow.
  • The DBMS_RANDOM engine uses Oracle’s own random package to generate random data
  • The “TOAD_DATAGEN” provides the same flexibility as the internal engine without suffering from performance issues of the internal engine for large data sets; however, it requires installing the TOAD_DATAGEN package to the server.
    You can also enable “Enforce Referential Integrity” to make sure that master/detail relationships remain intact.

-John

5

Good Morning TOAD Team,

Thank you! Both ways work fine this week; I don’t know why I could not get the + to function last week. I guess real looking data is no longer available; random works. :slight_smile:

6

Hey Larry,

I’m glad you have part of it working for you! When you said “real looking data is no longer available”, which engine are you using to generate the random data: Internal, DBMS_RANDOM, or TOAD_DATAGEN?

-John

7

Good Afternoon John,

            I tried the first two options since the TOAD_DATAGEN option failed.  Does the TOAD_DATAGEN option offer real looking fake data?

Larry Wickliffe

Monitoring, Performance and Tuning Services Lead, Data and Business Intelligence Services (DABIS)

Office of Information Systems and Technology (OIST)

Employment and Training Administration (ETA). US Department of Labor

Wickliffe.Larry@dol.gov: 202-693-3485 FPB

l.wickliffe@computer.org 703-508-4945 Cell

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Monday, November 13, 2017 10:46 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Database Import Generate Data

RE: Database Import Generate Data

Reply by John Bowman

Hey Larry,

I’m glad you have part of it working for you! When you said “real looking data is no longer available”, which engine are you using to generate the random data: Internal, DBMS_RANDOM, or TOAD_DATAGEN?

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

8

Hey Larry,

Both the Internal engine and the TOAD_DATAGEN engine offer real-looking fake data, yes. The real-looking data is primarily for character columns and allow you to select items such as the following:

GenerateData_Dept.jpeg
GenerateData_Dept.jpeg930×629 85.2 KB

In order to use the TOAD_DATAGEN package, it must first be installed on the server. To do that, click the Toad Wizard icon in the toolbar of the window to launch the Server Side Objects wizard and install the package. Once installed, you should be able to select it from the General Options page.

-John