{ "source": { "server": "slc15all.us.oracle.com" }, "position": { "snapshot": true, "scn": 16457443381643, "snapshot_completed": false }, "databaseName": "SLC15ALL", "schemaName": "HIVE", "ddl": "\n CREATE TABLE \"HIVE\".\"DBS\" \n (\t\"DB_ID\" NUMBER NOT NULL ENABLE, \n\t\"DESC\" VARCHAR2(4000), \n\t\"DB_LOCATION_URI\" VARCHAR2(4000) NOT NULL ENABLE, \n\t\"NAME\" VARCHAR2(128), \n\t\"OWNER_NAME\" VARCHAR2(128), \n\t\"OWNER_TYPE\" VARCHAR2(10), \n\t CONSTRAINT \"DBS_PK\" PRIMARY KEY (\"DB_ID\")\n USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS \n STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645\n PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1\n BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)\n TABLESPACE \"SYSTEM\" ENABLE, \n\t SUPPLEMENTAL LOG DATA (ALL) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS\n ) SEGMENT CREATION IMMEDIATE \n PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 \n NOCOMPRESS LOGGING\n STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645\n PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1\n BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)\n TABLESPACE \"SYSTEM\" ", "tableChanges": [ { "type": "CREATE", "id": "\"SLC15ALL\".\"HIVE\".\"DBS\"", "table": { "defaultCharsetName": null, "primaryKeyColumnNames": [ "DB_ID" ], "columns": [ { "name": "DB_ID", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 0, "position": 1, "optional": false, "autoIncremented": false, "generated": false }, { "name": "DESC", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4000, "position": 2, "optional": true, "autoIncremented": false, "generated": false }, { "name": "DB_LOCATION_URI", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4000, "position": 3, "optional": false, "autoIncremented": false, "generated": false }, { "name": "NAME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 128, "position": 4, "optional": true, "autoIncremented": false, "generated": false }, { "name": "OWNER_NAME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 128, "position": 5, "optional": true, "autoIncremented": false, "generated": false }, { "name": "OWNER_TYPE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 10, "position": 6, "optional": true, "autoIncremented": false, "generated": false } ] } } ] }