Skip to content

Instantly share code, notes, and snippets.

@sudoremo

sudoremo/5.1.txt

Created May 7, 2018 08:28
Show Gist options
  • Save sudoremo/16cd14dca870b80d45ca21c7fc1afe60 to your computer and use it in GitHub Desktop.
Save sudoremo/16cd14dca870b80d45ca21c7fc1afe60 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
5.1.txt
Fetching gem metadata from https://rubygems.org/...........
Fetching version metadata from https://rubygems.org/..
Resolving dependencies....
Using concurrent-ruby 1.0.5
Using minitest 5.11.3
Using thread_safe 0.3.6
Using arel 8.0.0
Using ruby-plsql 0.6.0
Using coderay 1.1.2
Using ffi 1.9.23
Using method_source 0.9.0
Using bundler 1.13.6
Using i18n 1.0.1
Using tzinfo 1.2.5
Using spoon 0.0.6
Using activesupport 5.1.6
Using pry 0.11.3
Using activemodel 5.1.6
Using activerecord 5.1.6
Using activerecord-oracle_enhanced-adapter 1.8.2
-- create_table(:table_0, {:force=>true})
D, [2018-05-07T10:27:59.820000 #1142] DEBUG -- : (165.0ms) DROP TABLE "TABLE_0"
D, [2018-05-07T10:27:59.856000 #1142] DEBUG -- : (32.0ms) DROP SEQUENCE "TABLE_0_SEQ"
D, [2018-05-07T10:27:59.914000 #1142] DEBUG -- : (49.0ms) CREATE TABLE "TABLE_0" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:27:59.919000 #1142] DEBUG -- : (4.0ms) CREATE SEQUENCE "TABLE_0_SEQ" START WITH 10000
-> 2.8653s
-- create_table(:table_1, {:force=>true})
D, [2018-05-07T10:28:01.821000 #1142] DEBUG -- : (15.0ms) DROP TABLE "TABLE_1"
D, [2018-05-07T10:28:01.827000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_1_SEQ"
D, [2018-05-07T10:28:01.859000 #1142] DEBUG -- : (23.0ms) CREATE TABLE "TABLE_1" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:01.864000 #1142] DEBUG -- : (4.0ms) CREATE SEQUENCE "TABLE_1_SEQ" START WITH 10000
-> 1.9433s
-- create_table(:table_2, {:force=>true})
D, [2018-05-07T10:28:03.757000 #1142] DEBUG -- : (30.0ms) DROP TABLE "TABLE_2"
D, [2018-05-07T10:28:03.763000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_2_SEQ"
D, [2018-05-07T10:28:03.800000 #1142] DEBUG -- : (29.0ms) CREATE TABLE "TABLE_2" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:03.804000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_2_SEQ" START WITH 10000
-> 1.9397s
-- create_table(:table_3, {:force=>true})
D, [2018-05-07T10:28:05.693000 #1142] DEBUG -- : (14.0ms) DROP TABLE "TABLE_3"
D, [2018-05-07T10:28:05.698000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_3_SEQ"
D, [2018-05-07T10:28:05.728000 #1142] DEBUG -- : (22.0ms) CREATE TABLE "TABLE_3" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:05.734000 #1142] DEBUG -- : (5.0ms) CREATE SEQUENCE "TABLE_3_SEQ" START WITH 10000
-> 1.9296s
-- create_table(:table_4, {:force=>true})
D, [2018-05-07T10:28:07.592000 #1142] DEBUG -- : (29.0ms) DROP TABLE "TABLE_4"
D, [2018-05-07T10:28:07.600000 #1142] DEBUG -- : (6.0ms) DROP SEQUENCE "TABLE_4_SEQ"
D, [2018-05-07T10:28:07.617000 #1142] DEBUG -- : (12.0ms) CREATE TABLE "TABLE_4" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:07.621000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_4_SEQ" START WITH 10000
-> 1.8861s
-- create_table(:table_5, {:force=>true})
D, [2018-05-07T10:28:09.568000 #1142] DEBUG -- : (25.0ms) DROP TABLE "TABLE_5"
D, [2018-05-07T10:28:09.574000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_5_SEQ"
D, [2018-05-07T10:28:09.591000 #1142] DEBUG -- : (11.0ms) CREATE TABLE "TABLE_5" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:09.610000 #1142] DEBUG -- : (18.0ms) CREATE SEQUENCE "TABLE_5_SEQ" START WITH 10000
-> 1.9878s
-- create_table(:table_6, {:force=>true})
D, [2018-05-07T10:28:11.464000 #1142] DEBUG -- : (14.0ms) DROP TABLE "TABLE_6"
D, [2018-05-07T10:28:11.471000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_6_SEQ"
D, [2018-05-07T10:28:11.507000 #1142] DEBUG -- : (26.0ms) CREATE TABLE "TABLE_6" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:11.511000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_6_SEQ" START WITH 10000
-> 1.9010s
-- create_table(:table_7, {:force=>true})
D, [2018-05-07T10:28:11.621000 #1142] DEBUG -- : (16.0ms) DROP TABLE "TABLE_7"
D, [2018-05-07T10:28:11.626000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_7_SEQ"
D, [2018-05-07T10:28:11.658000 #1142] DEBUG -- : (28.0ms) CREATE TABLE "TABLE_7" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:11.663000 #1142] DEBUG -- : (4.0ms) CREATE SEQUENCE "TABLE_7_SEQ" START WITH 10000
-> 0.1511s
-- create_table(:table_8, {:force=>true})
D, [2018-05-07T10:28:11.772000 #1142] DEBUG -- : (16.0ms) DROP TABLE "TABLE_8"
D, [2018-05-07T10:28:11.776000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_8_SEQ"
D, [2018-05-07T10:28:11.803000 #1142] DEBUG -- : (23.0ms) CREATE TABLE "TABLE_8" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:11.809000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_8_SEQ" START WITH 10000
-> 0.1455s
-- create_table(:table_9, {:force=>true})
D, [2018-05-07T10:28:11.935000 #1142] DEBUG -- : (33.0ms) DROP TABLE "TABLE_9"
D, [2018-05-07T10:28:11.941000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_9_SEQ"
D, [2018-05-07T10:28:11.961000 #1142] DEBUG -- : (12.0ms) CREATE TABLE "TABLE_9" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:11.965000 #1142] DEBUG -- : (2.0ms) CREATE SEQUENCE "TABLE_9_SEQ" START WITH 10000
-> 0.1558s
-- create_table(:table_10, {:force=>true})
D, [2018-05-07T10:28:12.092000 #1142] DEBUG -- : (36.0ms) DROP TABLE "TABLE_10"
D, [2018-05-07T10:28:12.100000 #1142] DEBUG -- : (7.0ms) DROP SEQUENCE "TABLE_10_SEQ"
D, [2018-05-07T10:28:12.117000 #1142] DEBUG -- : (12.0ms) CREATE TABLE "TABLE_10" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.121000 #1142] DEBUG -- : (2.0ms) CREATE SEQUENCE "TABLE_10_SEQ" START WITH 10000
-> 0.1550s
-- create_table(:table_11, {:force=>true})
D, [2018-05-07T10:28:12.238000 #1142] DEBUG -- : (25.0ms) DROP TABLE "TABLE_11"
D, [2018-05-07T10:28:12.244000 #1142] DEBUG -- : (6.0ms) DROP SEQUENCE "TABLE_11_SEQ"
D, [2018-05-07T10:28:12.262000 #1142] DEBUG -- : (14.0ms) CREATE TABLE "TABLE_11" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.282000 #1142] DEBUG -- : (19.0ms) CREATE SEQUENCE "TABLE_11_SEQ" START WITH 10000
-> 0.1610s
-- create_table(:table_12, {:force=>true})
D, [2018-05-07T10:28:12.390000 #1142] DEBUG -- : (15.0ms) DROP TABLE "TABLE_12"
D, [2018-05-07T10:28:12.396000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_12_SEQ"
D, [2018-05-07T10:28:12.436000 #1142] DEBUG -- : (32.0ms) CREATE TABLE "TABLE_12" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.447000 #1142] DEBUG -- : (5.0ms) CREATE SEQUENCE "TABLE_12_SEQ" START WITH 10000
-> 0.1650s
-- create_table(:table_13, {:force=>true})
D, [2018-05-07T10:28:12.571000 #1142] DEBUG -- : (16.0ms) DROP TABLE "TABLE_13"
D, [2018-05-07T10:28:12.584000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_13_SEQ"
D, [2018-05-07T10:28:12.625000 #1142] DEBUG -- : (36.0ms) CREATE TABLE "TABLE_13" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.630000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_13_SEQ" START WITH 10000
-> 0.1824s
-- create_table(:table_14, {:force=>true})
D, [2018-05-07T10:28:12.738000 #1142] DEBUG -- : (15.0ms) DROP TABLE "TABLE_14"
D, [2018-05-07T10:28:12.744000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_14_SEQ"
D, [2018-05-07T10:28:12.778000 #1142] DEBUG -- : (29.0ms) CREATE TABLE "TABLE_14" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.782000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_14_SEQ" START WITH 10000
-> 0.1513s
-- create_table(:table_15, {:force=>true})
D, [2018-05-07T10:28:12.909000 #1142] DEBUG -- : (32.0ms) DROP TABLE "TABLE_15"
D, [2018-05-07T10:28:12.914000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_15_SEQ"
D, [2018-05-07T10:28:12.946000 #1142] DEBUG -- : (29.0ms) CREATE TABLE "TABLE_15" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:12.952000 #1142] DEBUG -- : (4.0ms) CREATE SEQUENCE "TABLE_15_SEQ" START WITH 10000
-> 0.1696s
-- create_table(:table_16, {:force=>true})
D, [2018-05-07T10:28:13.079000 #1142] DEBUG -- : (28.0ms) DROP TABLE "TABLE_16"
D, [2018-05-07T10:28:13.085000 #1142] DEBUG -- : (5.0ms) DROP SEQUENCE "TABLE_16_SEQ"
D, [2018-05-07T10:28:13.123000 #1142] DEBUG -- : (33.0ms) CREATE TABLE "TABLE_16" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:13.128000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_16_SEQ" START WITH 10000
-> 0.1745s
-- create_table(:table_17, {:force=>true})
D, [2018-05-07T10:28:13.243000 #1142] DEBUG -- : (16.0ms) DROP TABLE "TABLE_17"
D, [2018-05-07T10:28:13.265000 #1142] DEBUG -- : (21.0ms) DROP SEQUENCE "TABLE_17_SEQ"
D, [2018-05-07T10:28:13.283000 #1142] DEBUG -- : (14.0ms) CREATE TABLE "TABLE_17" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:13.287000 #1142] DEBUG -- : (4.0ms) CREATE SEQUENCE "TABLE_17_SEQ" START WITH 10000
-> 0.1588s
-- create_table(:table_18, {:force=>true})
D, [2018-05-07T10:28:13.409000 #1142] DEBUG -- : (29.0ms) DROP TABLE "TABLE_18"
D, [2018-05-07T10:28:13.415000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_18_SEQ"
D, [2018-05-07T10:28:13.451000 #1142] DEBUG -- : (33.0ms) CREATE TABLE "TABLE_18" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:13.455000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_18_SEQ" START WITH 10000
-> 0.1676s
-- create_table(:table_19, {:force=>true})
D, [2018-05-07T10:28:13.575000 #1142] DEBUG -- : (28.0ms) DROP TABLE "TABLE_19"
D, [2018-05-07T10:28:13.580000 #1142] DEBUG -- : (4.0ms) DROP SEQUENCE "TABLE_19_SEQ"
D, [2018-05-07T10:28:13.610000 #1142] DEBUG -- : (27.0ms) CREATE TABLE "TABLE_19" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "STRING_COLUMN_0" VARCHAR2(255), "INTEGER_COLUMN_0" NUMBER(38), "STRING_COLUMN_1" VARCHAR2(255), "INTEGER_COLUMN_1" NUMBER(38), "STRING_COLUMN_2" VARCHAR2(255), "INTEGER_COLUMN_2" NUMBER(38), "STRING_COLUMN_3" VARCHAR2(255), "INTEGER_COLUMN_3" NUMBER(38), "STRING_COLUMN_4" VARCHAR2(255), "INTEGER_COLUMN_4" NUMBER(38), "STRING_COLUMN_5" VARCHAR2(255), "INTEGER_COLUMN_5" NUMBER(38), "STRING_COLUMN_6" VARCHAR2(255), "INTEGER_COLUMN_6" NUMBER(38), "STRING_COLUMN_7" VARCHAR2(255), "INTEGER_COLUMN_7" NUMBER(38), "STRING_COLUMN_8" VARCHAR2(255), "INTEGER_COLUMN_8" NUMBER(38), "STRING_COLUMN_9" VARCHAR2(255), "INTEGER_COLUMN_9" NUMBER(38))
D, [2018-05-07T10:28:13.614000 #1142] DEBUG -- : (3.0ms) CREATE SEQUENCE "TABLE_19_SEQ" START WITH 10000
-> 0.1587s
D, [2018-05-07T10:28:13.685000 #1142] DEBUG -- : (7.0ms) SELECT SYS_CONTEXT('userenv', 'current_schema') FROM dual
D, [2018-05-07T10:28:14.287000 #1142] DEBUG -- : (425.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'AR_INTERNAL_METADATA' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:14.355000 #1142] DEBUG -- : ActiveRecord::InternalMetadata Load (34.0ms) SELECT "AR_INTERNAL_METADATA".* FROM "AR_INTERNAL_METADATA" WHERE "AR_INTERNAL_METADATA"."KEY" = :a1 AND ROWNUM <= :a2 [["key", "environment"], ["LIMIT", 1]]
D, [2018-05-07T10:28:14.364000 #1142] DEBUG -- : (2.0ms) SELECT SYS_CONTEXT('userenv', 'current_schema') FROM dual
D, [2018-05-07T10:28:14.446000 #1142] DEBUG -- : SQL (4.0ms) UPDATE "AR_INTERNAL_METADATA" SET "VALUE" = :a1, "UPDATED_AT" = :a2 WHERE "AR_INTERNAL_METADATA"."KEY" = :a3 [["value", "default_env"], ["updated_at", "2018-05-07 08:28:14.428000"], ["key", "environment"]]
Run options: --seed 15879
# Running:
D, [2018-05-07T10:28:14.775000 #1142] DEBUG -- : (92.0ms) SELECT LOWER(view_name) FROM all_views WHERE owner = SYS_CONTEXT('userenv', 'current_schema')
D, [2018-05-07T10:28:14.890000 #1142] DEBUG -- : Sequence (26.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_0_seq')
D, [2018-05-07T10:28:17.068000 #1142] DEBUG -- : Primary Key (2177.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_0' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:17.080000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_0".* FROM "TABLE_0" ORDER BY "TABLE_0"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:17.529000 #1142] DEBUG -- : (357.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_0' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:17.640000 #1142] DEBUG -- : Sequence (3.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_1_seq')
D, [2018-05-07T10:28:19.598000 #1142] DEBUG -- : Primary Key (1957.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_1' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:19.607000 #1142] DEBUG -- : Load (7.0ms) SELECT * FROM (SELECT "TABLE_1".* FROM "TABLE_1" ORDER BY "TABLE_1"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:20.072000 #1142] DEBUG -- : (367.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_1' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:20.192000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_2_seq')
D, [2018-05-07T10:28:20.196000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_2' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:20.204000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_2".* FROM "TABLE_2" ORDER BY "TABLE_2"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:20.712000 #1142] DEBUG -- : (413.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_2' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:20.817000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_3_seq')
D, [2018-05-07T10:28:20.821000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_3' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:20.830000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_3".* FROM "TABLE_3" ORDER BY "TABLE_3"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:21.340000 #1142] DEBUG -- : (419.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_3' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:21.451000 #1142] DEBUG -- : Sequence (1.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_4_seq')
D, [2018-05-07T10:28:21.454000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_4' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:21.462000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_4".* FROM "TABLE_4" ORDER BY "TABLE_4"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:22.066000 #1142] DEBUG -- : (514.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_4' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:22.173000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_5_seq')
D, [2018-05-07T10:28:22.177000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_5' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:22.186000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_5".* FROM "TABLE_5" ORDER BY "TABLE_5"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:22.655000 #1142] DEBUG -- : (374.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_5' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:22.758000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_6_seq')
D, [2018-05-07T10:28:22.762000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_6' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:22.769000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_6".* FROM "TABLE_6" ORDER BY "TABLE_6"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:22.877000 #1142] DEBUG -- : (17.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_6' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:23.042000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_7_seq')
D, [2018-05-07T10:28:23.046000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_7' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:23.056000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_7".* FROM "TABLE_7" ORDER BY "TABLE_7"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:23.522000 #1142] DEBUG -- : (372.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_7' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:23.626000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_8_seq')
D, [2018-05-07T10:28:23.630000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_8' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:23.636000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_8".* FROM "TABLE_8" ORDER BY "TABLE_8"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:24.085000 #1142] DEBUG -- : (358.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_8' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:24.186000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_9_seq')
D, [2018-05-07T10:28:24.189000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_9' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:24.197000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_9".* FROM "TABLE_9" ORDER BY "TABLE_9"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:24.649000 #1142] DEBUG -- : (356.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_9' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:24.759000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_10_seq')
D, [2018-05-07T10:28:24.763000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_10' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:24.775000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_10".* FROM "TABLE_10" ORDER BY "TABLE_10"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:25.293000 #1142] DEBUG -- : (424.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_10' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:25.401000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_11_seq')
D, [2018-05-07T10:28:25.405000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_11' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:25.417000 #1142] DEBUG -- : Load (8.0ms) SELECT * FROM (SELECT "TABLE_11".* FROM "TABLE_11" ORDER BY "TABLE_11"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:25.996000 #1142] DEBUG -- : (487.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_11' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:26.099000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_12_seq')
D, [2018-05-07T10:28:26.102000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_12' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:26.113000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_12".* FROM "TABLE_12" ORDER BY "TABLE_12"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:26.705000 #1142] DEBUG -- : (503.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_12' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:26.807000 #1142] DEBUG -- : Sequence (1.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_13_seq')
D, [2018-05-07T10:28:26.811000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_13' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:26.818000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_13".* FROM "TABLE_13" ORDER BY "TABLE_13"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:26.927000 #1142] DEBUG -- : (16.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_13' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:27.031000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_14_seq')
D, [2018-05-07T10:28:27.035000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_14' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:27.044000 #1142] DEBUG -- : Load (7.0ms) SELECT * FROM (SELECT "TABLE_14".* FROM "TABLE_14" ORDER BY "TABLE_14"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:27.151000 #1142] DEBUG -- : (15.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_14' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:27.261000 #1142] DEBUG -- : Sequence (1.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_15_seq')
D, [2018-05-07T10:28:27.265000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_15' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:27.272000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_15".* FROM "TABLE_15" ORDER BY "TABLE_15"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:27.376000 #1142] DEBUG -- : (15.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_15' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:27.487000 #1142] DEBUG -- : Sequence (1.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_16_seq')
D, [2018-05-07T10:28:27.490000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_16' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:27.503000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_16".* FROM "TABLE_16" ORDER BY "TABLE_16"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:27.614000 #1142] DEBUG -- : (15.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_16' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:27.724000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_17_seq')
D, [2018-05-07T10:28:27.728000 #1142] DEBUG -- : Primary Key (2.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_17' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:27.737000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_17".* FROM "TABLE_17" ORDER BY "TABLE_17"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:27.842000 #1142] DEBUG -- : (18.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_17' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:27.950000 #1142] DEBUG -- : Sequence (1.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_18_seq')
D, [2018-05-07T10:28:27.953000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_18' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:27.961000 #1142] DEBUG -- : Load (5.0ms) SELECT * FROM (SELECT "TABLE_18".* FROM "TABLE_18" ORDER BY "TABLE_18"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:28.069000 #1142] DEBUG -- : (15.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_18' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
D, [2018-05-07T10:28:28.169000 #1142] DEBUG -- : Sequence (2.0ms) select us.sequence_name from all_sequences us where us.sequence_owner = 'RFRITZSCHE4' and us.sequence_name = upper('TABLE_19_seq')
D, [2018-05-07T10:28:28.172000 #1142] DEBUG -- : Primary Key (3.0ms) SELECT cc.column_name FROM all_constraints c, all_cons_columns cc WHERE c.owner = 'RFRITZSCHE4' AND c.table_name = 'TABLE_19' AND c.constraint_type = 'P' AND cc.owner = c.owner AND cc.constraint_name = c.constraint_name
D, [2018-05-07T10:28:28.180000 #1142] DEBUG -- : Load (6.0ms) SELECT * FROM (SELECT "TABLE_19".* FROM "TABLE_19" ORDER BY "TABLE_19"."ID" ASC ) WHERE ROWNUM <= :a1 [["LIMIT", 1]]
D, [2018-05-07T10:28:28.284000 #1142] DEBUG -- : (15.0ms) SELECT cols.column_name AS name, cols.data_type AS sql_type, cols.data_default, cols.nullable, cols.virtual_column, cols.hidden_column, cols.data_type_owner AS sql_type_owner, DECODE(cols.data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale, comments.comments as column_comment FROM all_tab_cols cols, all_col_comments comments WHERE cols.owner = 'RFRITZSCHE4' AND cols.table_name = 'TABLE_19' AND cols.hidden_column = 'NO' AND cols.owner = comments.owner AND cols.table_name = comments.table_name AND cols.column_name = comments.column_name ORDER BY cols.column_id
BENCHMARK:
4.650000 0.190000 4.840000 ( 13.769034)
.
Finished in 13.784104s, 0.0725 runs/s, 0.0000 assertions/s.
1 runs, 0 assertions, 0 failures, 0 errors, 0 skips
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment