Create the initial Swingbench tables and load them with data. This takes about 25 minutes to run. This is using the command line version of Swingbench (-cl).
1. Logon as oracle (password is oracle).
| No Format |
|---|
su - oracle |
2. Run the swingbench command to create and load the tables.
...
| No Format |
|---|
/u01/oracle/swingbench/bin/oewizard -cl -create -cs //source-int/pdb1 -scale 1 -u oe -p oe -ts users -tc 7 -v -dba system -dbap oracle |
| Note |
|---|
The "scale" factor is used to indicate the size of the data set that is created. If a smaller dataset is required, then decrease the scale. For example: "-scale 0.5" |
The output is:
| No Format |
|---|
SwingBench Wizard Author : Dominic Giles Version : 2.5.0.932 Running in Lights Out Mode using config file : oewizard.xml Connecting to : jdbc:oracle:thin:@//source-int/pdb1 Connected Starting run Starting script ../sql/soedgdrop2.sql Script completed in 0 hour(s) 0 minute(s) 1 second(s) 755 millisecond(s) Starting script ../sql/soedgcreatetables2.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 549 millisecond(s) Starting script ../sql/soedgviews.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 62 millisecond(s) Starting script ../sql/soedgsqlset.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 184 millisecond(s) Inserting data into table ADDRESSES_750000 Inserting data into table ADDRESSES_1 Inserting data into table CUSTOMERS_1 Inserting data into table ORDER_ITEMS_714895 Inserting data into table CUSTOMERS_500000 Inserting data into table ORDERS_714895 Inserting data into table ORDERS_1 Inserting data into table ORDER_ITEMS_1 Completed processing table ADDRESSES_750000 in 0:02:31 Completed processing table ADDRESSES_1 in 0:02:36 Inserting data into table CARD_DETAILS_750000 Completed processing table CUSTOMERS_500000 in 0:03:48 Inserting data into table CARD_DETAILS_1 Completed processing table CARD_DETAILS_750000 in 0:01:15 Inserting data into table LOGON_1191492 Completed processing table CUSTOMERS_1 in 0:04:04 Inserting data into table LOGON_1 Completed processing table LOGON_1191492 in 0:01:01 Inserting data into table PRODUCT_INFORMATION Inserting data into table INVENTORIES Completed processing table PRODUCT_INFORMATION in 0:00:00 Completed processing table CARD_DETAILS_1 in 0:01:14 Inserting data into table PRODUCT_DESCRIPTIONS Completed processing table PRODUCT_DESCRIPTIONS in 0:00:01 Inserting data into table WAREHOUSES Completed processing table WAREHOUSES in 0:00:00 Completed processing table LOGON_1 in 0:01:00 Completed processing table INVENTORIES in 0:00:34 Completed processing table ORDERS_714895 in 0:07:28 Completed processing table ORDERS_1 in 0:07:29 Completed processing table ORDER_ITEMS_714895 in 0:07:31 Connection cache closed Starting script ../sql/soedganalyzeschema2.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 346 millisecond(s) Starting script ../sql/soedgconstraints2.sql Script completed in 0 hour(s) 0 minute(s) 51 second(s) 162 millisecond(s) Starting script ../sql/soedgindexes2.sql Script completed in 0 hour(s) 1 minute(s) 19 second(s) 941 millisecond(s) Starting script ../sql/soedgsequences2.sql Script completed in 0 hour(s) 0 minute(s) 3 second(s) 61 millisecond(s) Starting script ../sql/soedgpackage2_header.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 724 millisecond(s) Starting script ../sql/soedgpackage2_body.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 558 millisecond(s) Starting script ../sql/soedgsetupmetadata.sql Script completed in 0 hour(s) 0 minute(s) 2 second(s) 262 millisecond(s) |
...