FINE 302854 0 oracle.javatools.ui.GraphicsUtils adjusted point = java.awt.Point[x=350,y=10]
FINE 302853 0 oracle.javatools.ui.GraphicsUtils popup menu show point = java.awt.Point[x=708,y=574]
FINE 302852 0 oracle.javatools.ui.GraphicsUtils yOffset = -20
FINE 302851 0 oracle.javatools.ui.GraphicsUtils xOffset = 0
FINE 302850 1 oracle.javatools.ui.GraphicsUtils non-zero offset indicates popup point was adjusted to ensure it doesn't extend beyond the display rectangle
FINE 302849 0 oracle.javatools.ui.GraphicsUtils screen size = java.awt.Dimension[width=1366,height=696]
FINE 302848 289822 oracle.javatools.ui.GraphicsUtils popup menu preferred size = java.awt.Dimension[width=158,height=122]
INFO 302847 66866 oracle.dbtools.raptor.data.writers.ImportGenInsertExec$DBTaskListener Sending information to SQL Worksheet
INFO 2642 0 oracle.dbtools.raptor.data.writers.ImportGenInsertExec$1 Sending information to SQL Worksheet
INFO 2641 1 oracle.dbtools.raptor.data.writers.ImportGenInsertExec Sending import to table
INFO 2640 30858 oracle.dbtools.raptor.data.writers.ImportGen Starting Generation
FINE 2637 0 oracle.javatools.ui.GraphicsUtils adjusted point = java.awt.Point[x=152,y=5642]
FINE 2636 0 oracle.javatools.ui.GraphicsUtils popup menu show point = java.awt.Point[x=265,y=299]
FINE 2635 0 oracle.javatools.ui.GraphicsUtils yOffset = 0
FINE 2634 0 oracle.javatools.ui.GraphicsUtils xOffset = 0
FINE 2633 0 oracle.javatools.ui.GraphicsUtils non-zero offset indicates popup point was adjusted to ensure it doesn't extend beyond the display rectangle
FINE 2632 1 oracle.javatools.ui.GraphicsUtils screen size = java.awt.Dimension[width=1366,height=696]
FINE 2631 11 oracle.javatools.ui.GraphicsUtils popup menu preferred size = java.awt.Dimension[width=176,height=366]
INFO 2630 1 oracle.dbtools.raptor.dialogs.BasicObjectModifier oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@76520403, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.EVENT=java.awt.event.MouseEvent[MOUSE_RELEASED,(152,5642),absolute(265,299),button=3,modifiers=Meta+Button3,extModifiers=Meta,clickCount=1] on nav-DatabaseNavigatorWindow.Default, ObjectAction.CONN_NAME=IdeConnections%23dom, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@52ebd30f, Context.VIEW=DatabaseNavigatorWindow.Default, Context.SELECTION=[Loracle.ide.model.Element;@711ddb2}]
INFO 2629 2709 oracle.dbtools.raptor.dialogs.BasicObjectModifier Finding Context Menu for:Oracle#TABLE:SEGMENT_BCKUP
INFO 2628 51 oracle.dbtools.raptor.controls.grid.RaptorGridPersistedSettings Persisted settings for this table could not be loaded
INFO 2623 0 oracle.dbtools.raptor.controls.grid.RaptorGridPersistedSettings Persisted settings for this table could not be loaded
INFO 2622 3 oracle.dbtools.raptor.controls.grid.RaptorGridPersistedSettings Persisted settings for this table could not be loaded
FINER 2620 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_OWNER=NETUSER
FINER 2619 0 oracle.dbtools.raptor.controls.display.DisplayResultTable TYPE=TABLE
FINER 2618 1 oracle.dbtools.raptor.controls.display.DisplayResultTable GENERATED=N
FINER 2617 0 oracle.dbtools.raptor.controls.display.DisplayResultTable ID=140580
FINER 2616 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CONNECTION_NAME=dom
FINER 2615 0 oracle.dbtools.raptor.controls.display.DisplayResultTable PARTITIONED=NO
FINER 2614 0 oracle.dbtools.raptor.controls.display.DisplayResultTable TEMPORARY=N
FINER 2613 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_NAME=SEGMENT_BCKUP
FINER 2612 0 oracle.dbtools.raptor.controls.display.DisplayResultTable SCHEMA=NETUSER
FINER 2611 0 oracle.dbtools.raptor.controls.display.DisplayResultTable EXTERNAL=N
FINER 2610 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_ID=140580
FINER 2609 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CATALOG=
FINER 2608 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CREATED=2016-10-24
FINER 2607 0 oracle.dbtools.raptor.controls.display.DisplayResultTable IOT_TYPE=null
FINER 2606 0 oracle.dbtools.raptor.controls.display.DisplayResultTable NAME=SEGMENT_BCKUP
FINER 2605 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_FOLDER_TYPE=TABLE
FINER 2604 0 oracle.dbtools.raptor.controls.display.DisplayResultTable SHORT_NAME=null
FINER 2603 1 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_TYPE=TABLE
FINER 2602 0 oracle.dbtools.raptor.controls.display.DisplayResultTable COLUMN_NAME=null
FINER 2601 0 oracle.dbtools.raptor.controls.display.DisplayResultTable LAST_DDL_TIME=2016-10-24
FINER 2600 0 oracle.dbtools.raptor.controls.display.DisplayResultTable ConnectionType=Oracle
FINER 2599 1 oracle.dbtools.raptor.controls.display.DisplayResultTable CHILD_NAME=null
FINER 2598 3 oracle.dbtools.raptor.controls.display.DisplayResultTable DisplayResultTable.refresh(true)
FINER 2597 0 oracle.dbtools.raptor.controls.display.DisplayPanel DisplayPanel.Refresh(true} for Columns
FINER 2596 506 oracle.dbtools.raptor.controls.display.DisplayPanel DisplayPanel.Refresh()
FINER 2595 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_OWNER=NETUSER
FINER 2594 0 oracle.dbtools.raptor.controls.display.DisplayResultTable TYPE=TABLE
FINER 2593 0 oracle.dbtools.raptor.controls.display.DisplayResultTable GENERATED=N
FINER 2592 0 oracle.dbtools.raptor.controls.display.DisplayResultTable ID=140580
FINER 2591 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CONNECTION_NAME=dom
FINER 2590 0 oracle.dbtools.raptor.controls.display.DisplayResultTable PARTITIONED=NO
FINER 2589 0 oracle.dbtools.raptor.controls.display.DisplayResultTable TEMPORARY=N
FINER 2588 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_NAME=SEGMENT_BCKUP
FINER 2587 0 oracle.dbtools.raptor.controls.display.DisplayResultTable SCHEMA=NETUSER
FINER 2586 0 oracle.dbtools.raptor.controls.display.DisplayResultTable EXTERNAL=N
FINER 2585 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_ID=140580
FINER 2584 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CATALOG=
FINER 2583 0 oracle.dbtools.raptor.controls.display.DisplayResultTable CREATED=2016-10-24
FINER 2582 0 oracle.dbtools.raptor.controls.display.DisplayResultTable IOT_TYPE=null
FINER 2581 0 oracle.dbtools.raptor.controls.display.DisplayResultTable NAME=SEGMENT_BCKUP
FINER 2580 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_FOLDER_TYPE=TABLE
FINER 2579 0 oracle.dbtools.raptor.controls.display.DisplayResultTable SHORT_NAME=null
FINER 2578 0 oracle.dbtools.raptor.controls.display.DisplayResultTable OBJECT_TYPE=TABLE
FINER 2577 0 oracle.dbtools.raptor.controls.display.DisplayResultTable COLUMN_NAME=null
FINER 2576 0 oracle.dbtools.raptor.controls.display.DisplayResultTable LAST_DDL_TIME=2016-10-24
FINER 2575 0 oracle.dbtools.raptor.controls.display.DisplayResultTable ConnectionType=Oracle
FINER 2574 1 oracle.dbtools.raptor.controls.display.DisplayResultTable CHILD_NAME=null
FINER 2573 1 oracle.dbtools.raptor.controls.display.DisplayResultTable DisplayResultTable.refresh(true)
FINER 2572 1 oracle.dbtools.raptor.controls.display.DisplayPanel DisplayPanel.Refresh(true} for Columns
FINER 2571 11 oracle.dbtools.raptor.controls.display.DisplayPanel DisplayPanel.Refresh()
FINE 2570 9 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp resume
FINE 2569 0 oracle.dbtools.raptor.navigator.ObjectQueryInstance Elapsed Time: 144 ms
FINER 2568 148 oracle.dbtools.raptor.navigator.ObjectQueryInstance Loaded: SEGMENT_BCKUP
FINE 2562 5 oracle.javatools.db.AbstractDBObjectProvider fire schema object SEGMENT_BCKUP updated in dom
FINE 2561 7 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_ORACLE_SINGLE_OBJECT_QUERY*/
O.OBJECT_NAME, O.OBJECT_TYPE, O.OBJECT_ID, O.LAST_DDL_TIME
FROM SYS.ALL_OBJECTS O
WHERE O.OWNER = 'NETUSER'
AND O.OBJECT_NAME = 'SEGMENT_BCKUP'
AND O.OBJECT_TYPE = 'TABLE'
Binds used: 'NETUSER', 'SEGMENT_BCKUP', 'TABLE',
Executing query and processing results took 7.709907ms.
FINE 2555 300 oracle.javatools.db.execute.StatementWrapper dom:
ALTER TABLE SEGMENT_BCKUP
MODIFY (PONPORT VARCHAR2(2000 BYTE) )
ALTER TABLE SEGMENT_BCKUP
MODIFY (SEGMENT_NAME VARCHAR2(2000 BYTE) )
Executing query and processing results took 305.152938ms.
FINE 2551 2 oracle.javatools.db.AbstractDatabase ProgressBarThread: Connection is alive!
FINE 2550 14 oracle.javatools.db.AbstractDatabase ProgressBarThread: Connection is alive!
FINEST 2549 3 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINE 2548 1 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp query skipped for id I:TABLE:140580
FINER 2547 9 oracle.javatools.db.diff.Difference
XXXX null
XXXX null
SAME schema (NETUSER : NETUSER)
SAME indexes
XXXX columns
XXXX PONPORT 0 0
XXXX dataTypeUsage
XXXX attributeValues
SAME unit (BYTE : BYTE)
XXXX size (50 : 2000)
SAME dataTypeID (DataTypeID:VARCHAR2:Oracle Database:91 : DataTypeID:VARCHAR2:Oracle Database:91)
SAME name (null : null)
SAME properties ({dataTypeID=DataTypeID:VARCHAR2:Oracle Database:91} : {dataTypeID=DataTypeID:VARCHAR2:Oracle Database:91})
SAME default (null : null)
SAME virtualExpressionSource (null : null)
SAME notNull (false : false)
SAME name (PONPORT : PONPORT)
SAME identityProperties (null : null)
SAME properties
SAME Comment (null : null)
SAME ColumnSequenceExpander.ReuseSequence (null : null)
SAME inline (null : null)
SAME OracleColumnProperties (null : null)
SAME AUTO_GENERATED_SEQUENCE (null : null)
SAME AUTO_GENERATED_SEQUENCE_TRIGGER (null : null)
SAME ColumnSequenceExpander.TriggerNullCheck (null : null)
XXXX SEGMENT_NAME 1 1
XXXX dataTypeUsage
XXXX attributeValues
SAME unit (BYTE : BYTE)
XXXX size (50 : 2000)
SAME dataTypeID (DataTypeID:VARCHAR2:Oracle Database:91 : DataTypeID:VARCHAR2:Oracle Database:91)
SAME name (null : null)
SAME properties ({dataTypeID=DataTypeID:VARCHAR2:Oracle Database:91} : {dataTypeID=DataTypeID:VARCHAR2:Oracle Database:91})
SAME default (null : null)
SAME virtualExpressionSource (null : null)
SAME notNull (false : false)
SAME name (SEGMENT_NAME : SEGMENT_NAME)
SAME identityProperties (null : null)
SAME properties
SAME Comment (null : null)
SAME ColumnSequenceExpander.ReuseSequence (null : null)
SAME inline (null : null)
SAME OracleColumnProperties (null : null)
SAME AUTO_GENERATED_SEQUENCE (null : null)
SAME AUTO_GENERATED_SEQUENCE_TRIGGER (null : null)
SAME ColumnSequenceExpander.TriggerNullCheck (null : null)
SAME name (SEGMENT_BCKUP : SEGMENT_BCKUP)
SAME constraints
SAME properties
SAME Comment (null : null)
SAME OracleInMemoryColumnProperties
SAME TableType (NORMAL : NORMAL)
SAME OBJECT TABLE (null : null)
SAME HiveBucketProperties
SAME OracleInMemoryProperties
SAME OracleStorageProperties
SAME OracleTableProperties
SAME OracleTablePartitions
SAME HiveStorageProperties
SAME TBLPROPERTIES
SAME PARTITIONED TABLE (null : null)
SAME HiveSkewProperties
SAME HivePartitionProperties
SAME OracleExternalTableProperties
SAME OracleIndexOrganizedTableProperties
SAME NESTED TABLE (null : null)
FINEST 2546 5 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINEST 2545 6 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINEST 2544 7 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINE 2543 0 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on SEGMENT_NAME
FINE 2542 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2541 1 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2540 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2539 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2538 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2537 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2536 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2535 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2534 2 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINEST 2533 6 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINE 2532 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on SEGMENT_NAME
FINE 2531 2 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2530 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2529 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2528 4480 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINEST 2527 13 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINE 2526 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2525 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2524 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2523 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2522 7765 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINEST 2521 18 oracle.javatools.db.property.AbstractPropertyManager Property constraints: can ALTER on TABLE SEGMENT_BCKUP
FINE 2520 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on SEGMENT_NAME
FINE 2519 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2518 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2517 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2516 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2515 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2514 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2513 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2512 1 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2511 4 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2510 0 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2509 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2508 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2507 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2506 2604 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINER 2505 1 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building Comment of SEGMENT_BCKUP took 36ms
FINER 2504 0 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building Comment of SEGMENT_BCKUP took 35ms
FINE 2503 34 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_TABLE_COMMENT_QUERY*/
COMMENTS FROM SYS.ALL_TAB_COMMENTS WHERE OWNER = 'NETUSER' AND TABLE_NAME = 'SEGMENT_BCKUP' AND TABLE_TYPE = 'TABLE'
Binds used: 'NETUSER', 'SEGMENT_BCKUP', 'TABLE',
Executing query and processing results took 33.164822ms.
FINE 2497 1 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp query skipped for id I:TABLE:140580
FINEST 2496 13 oracle.javatools.db.property.AbstractPropertyManager Property Comment: can ALTER on TABLE SEGMENT_BCKUP
FINE 2495 0 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on SEGMENT_NAME
FINE 2494 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2493 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2492 1 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2491 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2490 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2489 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2488 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2487 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2486 23 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2485 1 oracle.javatools.db.validators.DBObjectValidator Skipping validation for virtualExpression on PONPORT
FINE 2484 0 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2483 1 oracle.javatools.db.property.PropertyHelper Unknown property dataTypeAttributes for class DataTypeUsage
FINE 2482 0 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINE 2481 619 oracle.javatools.db.property.PropertyHelper Unknown property Comment for class DataTypeUsage
FINEST 2480 66 oracle.javatools.db.property.AbstractPropertyManager Property columns: can ALTER on TABLE SEGMENT_BCKUP
FINE 2479 0 oracle.ide.db.components.ComponentWrapper will need replace for: TableType
FINEST 2478 1 oracle.javatools.db.property.AbstractPropertyManager Property TableType: cannot ALTER but can REPLACE on TABLE SEGMENT_BCKUP
FINE 2477 0 oracle.ide.db.components.ComponentWrapper will need replace for: TableType
FINEST 2476 1 oracle.javatools.db.property.AbstractPropertyManager Property TableType: cannot ALTER but can REPLACE on TABLE SEGMENT_BCKUP
FINEST 2475 1 oracle.javatools.db.property.AbstractPropertyManager Property name: can ALTER on TABLE SEGMENT_BCKUP
FINE 2474 1 oracle.ide.db.components.ComponentWrapper will need replace for: schema
FINEST 2473 79 oracle.javatools.db.property.AbstractPropertyManager Property schema: cannot ALTER but can REPLACE on TABLE SEGMENT_BCKUP
FINER 2472 0 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building constraints of SEGMENT_BCKUP took 729ms
FINER 2471 0 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building constraints of SEGMENT_BCKUP took 729ms
FINE 2470 729 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_CONSTRAINT_ENTERPRISE_QUERY*/
A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.SEARCH_CONDITION, A.R_OWNER,
A.R_CONSTRAINT_NAME, A.DELETE_RULE, A.STATUS, A.GENERATED,
NVL( A.INDEX_OWNER, A.OWNER ) INDEX_OWNER, A.INDEX_NAME,
DECODE( A.INDEX_NAME, NULL, NULL,
( SELECT OBJECT_ID FROM SYS.ALL_OBJECTS AO
WHERE AO.OBJECT_TYPE = 'INDEX'
AND AO.OBJECT_NAME = A.INDEX_NAME
AND AO.OWNER = NVL( A.INDEX_OWNER, A.OWNER ) ) ) INDEX_OBJECT_ID,
DECODE( A.R_CONSTRAINT_NAME, NULL, NULL,
( SELECT ( SELECT BB.OBJECT_TYPE || BB.OBJECT_ID
FROM SYS.ALL_OBJECTS BB
WHERE AA.OWNER = BB.OWNER
AND AA.TABLE_NAME = BB.OBJECT_NAME
AND BB.OBJECT_TYPE IN ('TABLE', 'VIEW') )
|| '#' || AA.TABLE_NAME
FROM SYS.ALL_CONSTRAINTS AA
WHERE AA.OWNER = A.R_OWNER
AND AA.CONSTRAINT_TYPE IN ( 'P', 'U' )
AND AA.CONSTRAINT_NAME = A.R_CONSTRAINT_NAME ) ) ref_relation_info,
( SELECT LISTAGG( REPLACE( B.COLUMN_NAME, ';', ';;' ), ';' )
WITHIN GROUP (ORDER BY B.POSITION)
FROM SYS.USER_CONS_COLUMNS B
WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.OWNER = B.OWNER ) concatcols,
A.DEFERRABLE, A.DEFERRED
FROM SYS.USER_CONSTRAINTS A
WHERE A.OWNER = 'NETUSER'
AND A.TABLE_NAME = 'SEGMENT_BCKUP'
AND A.CONSTRAINT_TYPE IN ( 'P', 'U', 'R', 'C' )
Binds used: 'NETUSER', 'SEGMENT_BCKUP',
Executing query and processing results took 727.429185ms.
FINE 2465 0 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp query skipped for id I:TABLE:140580
FINER 2464 1 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building columns of SEGMENT_BCKUP took 144ms
FINER 2463 1 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building columns of SEGMENT_BCKUP took 143ms
FINE 2462 142 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE11g_QUERY*/
C.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER,
C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE,
C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT,
( SELECT CMT.COMMENTS FROM SYS.ALL_COL_COMMENTS CMT
WHERE C.OWNER = CMT.OWNER
AND C.TABLE_NAME = CMT.TABLE_NAME
AND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS
, decode(C.CHAR_USED, 'B', 'BYTE', 'C', 'CHAR', null)
, C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, null, null
FROM SYS.ALL_TAB_COLS C
WHERE C.OWNER = 'NETUSER' AND C.TABLE_NAME = 'SEGMENT_BCKUP'
AND C.HIDDEN_COLUMN = 'NO'
ORDER BY C.COLUMN_ID
Binds used: 'NETUSER', 'SEGMENT_BCKUP',
Executing query and processing results took 141.278466ms.
FINE 2457 0 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp query skipped for id I:TABLE:140580
FINE 2456 134 oracle.ide.db.panels.PanelLibrary Preparing SEGMENT_BCKUP building: [columns]
WARNING 2455 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2454 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2453 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2452 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2451 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2450 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2449 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2448 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2447 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2446 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2445 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2444 0 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2443 1 oracle.javatools.db.ddl.BundleDDLGenerator$PropertiesDDLList Error: resource /oracle/dbtools/scheduler/Oracle10DDL.properties not found for ddl generation.
WARNING 2442 0 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: REALM CONSTRAINT.CREATE.SEQ
WARNING 2441 1 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: OLAPACL.CREATE.SEQ
WARNING 2440 1 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: REALM CONSTRAINT.CREATE.SEQ
WARNING 2439 1 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: OLAPACL.CREATE.SEQ
WARNING 2438 0 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: REALM CONSTRAINT.CREATE.SEQ
WARNING 2437 4 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: OLAPACL.CREATE.SEQ
WARNING 2436 0 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: REALM CONSTRAINT.CREATE.SEQ
WARNING 2435 2 oracle.javatools.db.ddl.BundleDDLGenerator unknown object type for: OLAPACL.CREATE.SEQ
FINE 2434 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2433 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2432 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2431 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2430 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2429 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2428 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2427 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2426 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2425 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2424 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2423 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2422 0 oracle.javatools.db.ddl.BundleDDLGenerator SCHDDLGenerator: no registered resource bundles
FINE 2421 0 oracle.javatools.db.ddl.BundleDDLGenerator CubeBundleDDLGenerator: no registered resource bundles
FINE 2420 0 oracle.javatools.db.ddl.BundleDDLGenerator CubeBundleDDLGenerator: no registered resource bundles
FINE 2419 1 oracle.javatools.db.ddl.BundleDDLGenerator CubeBundleDDLGenerator: no registered resource bundles
FINE 2418 32 oracle.javatools.db.ddl.BundleDDLGenerator CubeBundleDDLGenerator: no registered resource bundles
FINER 2417 0 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building TableType of SEGMENT_BCKUP took 49ms
FINER 2416 0 oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport Building TableType of SEGMENT_BCKUP took 47ms
FINE 2415 41 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_TABLE_TYPE_QUERY*/
A.TEMPORARY, A.DURATION, A.IOT_TYPE, A.PARTITIONED, A.NESTED,
( SELECT 1 FROM SYS.ALL_EXTERNAL_TABLES E WHERE E.OWNER = A.OWNER AND E.TABLE_NAME = A.TABLE_NAME ) EXTERNAL_TAB
FROM SYS.ALL_TABLES A
WHERE A.OWNER = 'NETUSER' AND A.TABLE_NAME = 'SEGMENT_BCKUP'
Binds used: 'NETUSER', 'SEGMENT_BCKUP',
Executing query and processing results took 40.574749ms.
FINE 2410 21 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_TIMESTAMP_BY_ID_10g_QUERY*/
AO.LAST_DDL_TIME FROM SYS.ALL_OBJECTS AO WHERE AO.OBJECT_ID = '140580' AND NOT EXISTS ( SELECT 1 FROM RECYCLEBIN RB WHERE RB.PURGE_OBJECT = AO.OBJECT_ID)
Binds used: '140580',
Executing query and processing results took 5.733211ms.
FINE 2406 2 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp suspend
FINE 2405 1 oracle.javatools.db.execute.StatementWrapper dom:
SELECT /*OracleDictionaryQueries.ALL_TIMESTAMP_BY_ID_10g_QUERY*/
AO.LAST_DDL_TIME FROM SYS.ALL_OBJECTS AO WHERE AO.OBJECT_ID = '140580' AND NOT EXISTS ( SELECT 1 FROM RECYCLEBIN RB WHERE RB.PURGE_OBJECT = AO.OBJECT_ID)
Binds used: '140580',
Executing query and processing results took 237.123718ms.
FINE 2404 235 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp resume
FINE 2399 2503 oracle.javatools.db.AbstractDBObjectProvider Database dom: timestamp suspend
FINE 2398 0 oracle.javatools.ui.GraphicsUtils adjusted point = java.awt.Point[x=151,y=5640]
FINE 2397 0 oracle.javatools.ui.GraphicsUtils popup menu show point = java.awt.Point[x=264,y=297]
FINE 2396 0 oracle.javatools.ui.GraphicsUtils yOffset = 0
FINE 2395 0 oracle.javatools.ui.GraphicsUtils xOffset = 0
FINE 2394 1 oracle.javatools.ui.GraphicsUtils non-zero offset indicates popup point was adjusted to ensure it doesn't extend beyond the display rectangle
FINE 2393 0 oracle.javatools.ui.GraphicsUtils screen size = java.awt.Dimension[width=1366,height=696]
FINE 2392 11 oracle.javatools.ui.GraphicsUtils popup menu preferred size = java.awt.Dimension[width=176,height=366]
INFO 2391 0 oracle.dbtools.raptor.dialogs.BasicObjectModifier oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@128e9086, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.EVENT=java.awt.event.MouseEvent[MOUSE_RELEASED,(151,5640),absolute(264,297),button=3,modifiers=Meta+Button3,extModifiers=Meta,clickCount=1] on nav-DatabaseNavigatorWindow.Default, ObjectAction.CONN_NAME=IdeConnections%23dom, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@7083f112, Context.VIEW=DatabaseNavigatorWindow.Default, Context.SELECTION=[Loracle.ide.model.Element;@4ce6bfea}]
INFO 2390 4008 oracle.dbtools.raptor.dialogs.BasicObjectModifier Finding Context Menu for:Oracle#TABLE:SEGMENT_BCKUP
INFO 2389 0 oracle.dbtools.raptor.controls.grid.RaptorGridTable$1 update returning false for Grid1oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@2f3fd17f, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, Context.VIEW=DatabaseNavigatorWindow.Default, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.SELECTION=[Loracle.ide.model.Element;@284944c9, Context.EVENT=null_key_12349123847123948712390487123904871239478}]
INFO 2388 0 oracle.dbtools.raptor.controls.grid.RaptorGridTable$1 update returning false for Grid1oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@1e0bffe, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, Context.VIEW=DatabaseNavigatorWindow.Default, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.SELECTION=[Loracle.ide.model.Element;@1dae5f01, Context.EVENT=null_key_12349123847123948712390487123904871239478}]
INFO 2387 0 oracle.dbtools.raptor.controls.grid.RaptorGridTable$1 update returning false for Grid1oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@32901675, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, Context.VIEW=DatabaseNavigatorWindow.Default, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.SELECTION=[Loracle.ide.model.Element;@647c61b0, Context.EVENT=null_key_12349123847123948712390487123904871239478}]
INFO 2386 1 oracle.dbtools.raptor.controls.grid.RaptorGridTable$1 update returning false for Grid1oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@76226b7a, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, Context.VIEW=DatabaseNavigatorWindow.Default, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.SELECTION=[Loracle.ide.model.Element;@3105baf1, Context.EVENT=null_key_12349123847123948712390487123904871239478}]
INFO 2385 6072 oracle.dbtools.raptor.controls.grid.RaptorGridTable$1 update returning false for Grid1oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@3476ec08, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, Context.VIEW=DatabaseNavigatorWindow.Default, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.SELECTION=[Loracle.ide.model.Element;@7364abdc, Context.EVENT=null_key_12349123847123948712390487123904871239478}]
INFO 2384 3 oracle.dbtools.raptor.data.writers.ImportGenInsertExec$DBTaskListener Sending information to SQL Worksheet
WARNING 2383 466 oracle.dbtools.raptor.data.writers.ImportGenInsertExec$DBTaskListener Import Data into table SEGMENT_BCKUP from file C:\Users\Roshanbi\Desktop\segment_info.csv . Task canceled and import rolled back. Task Canceled
WARNING 2381 383 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1001, maximum: 50)
WARNING 2280 530 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1002, maximum: 50)
WARNING 2179 655 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1002, maximum: 50)
WARNING 2078 1390 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1002, maximum: 50)
WARNING 1977 451247 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1002, maximum: 50)
WARNING 1876 170 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1002, maximum: 50)
INFO 1774 12 org.netbeans.core.netigso.Netigso$1 bundle oracle.external.antlr@12.2.0 started
INFO 1773 1 oracle.dbtools.raptor.data.writers.ImportGenInsertExec$1 Sending information to SQL Worksheet
INFO 1772 0 oracle.dbtools.raptor.data.writers.ImportGenInsertExec Sending import to table
INFO 1771 51690 oracle.dbtools.raptor.data.writers.ImportGen Starting Generation
FINE 1768 0 oracle.javatools.ui.GraphicsUtils adjusted point = java.awt.Point[x=139,y=5637]
FINE 1767 0 oracle.javatools.ui.GraphicsUtils popup menu show point = java.awt.Point[x=252,y=294]
FINE 1766 0 oracle.javatools.ui.GraphicsUtils yOffset = 0
FINE 1765 0 oracle.javatools.ui.GraphicsUtils xOffset = 0
FINE 1764 0 oracle.javatools.ui.GraphicsUtils non-zero offset indicates popup point was adjusted to ensure it doesn't extend beyond the display rectangle
FINE 1763 1 oracle.javatools.ui.GraphicsUtils screen size = java.awt.Dimension[width=1366,height=696]
FINE 1762 9 oracle.javatools.ui.GraphicsUtils popup menu preferred size = java.awt.Dimension[width=176,height=366]
INFO 1761 0 oracle.dbtools.raptor.dialogs.BasicObjectModifier oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@32ecba38, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.EVENT=java.awt.event.MouseEvent[MOUSE_RELEASED,(139,5637),absolute(252,294),button=3,modifiers=Meta+Button3,extModifiers=Meta,clickCount=1] on nav-DatabaseNavigatorWindow.Default, ObjectAction.CONN_NAME=IdeConnections%23dom, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@3b092f01, Context.VIEW=DatabaseNavigatorWindow.Default, Context.SELECTION=[Loracle.ide.model.Element;@17aa8f14}]
INFO 1760 3761 oracle.dbtools.raptor.dialogs.BasicObjectModifier Finding Context Menu for:Oracle#TABLE:SEGMENT_BCKUP
FINE 1759 0 oracle.javatools.ui.GraphicsUtils adjusted point = java.awt.Point[x=134,y=5636]
FINE 1758 0 oracle.javatools.ui.GraphicsUtils popup menu show point = java.awt.Point[x=247,y=293]
FINE 1757 0 oracle.javatools.ui.GraphicsUtils yOffset = 0
FINE 1756 0 oracle.javatools.ui.GraphicsUtils xOffset = 0
FINE 1755 1 oracle.javatools.ui.GraphicsUtils non-zero offset indicates popup point was adjusted to ensure it doesn't extend beyond the display rectangle
FINE 1754 0 oracle.javatools.ui.GraphicsUtils screen size = java.awt.Dimension[width=1366,height=696]
FINE 1753 13 oracle.javatools.ui.GraphicsUtils popup menu preferred size = java.awt.Dimension[width=176,height=366]
INFO 1752 1 oracle.dbtools.raptor.dialogs.BasicObjectModifier oracle.ide.Context[{NavigatorContext.NavigatorNodes=[Loracle.dbtools.raptor.navigator.model.NavigatorTreeNode;@6da27268, Context.WORKSPACE=Databases.jws, Context.PROJECT=IdeConnections%23dom.jpr, NavigatorContext.NavigatorTree=oracle.dbtools.raptor.navigator.model.NavigatorTree@1dab3216, Context.EVENT=java.awt.event.MouseEvent[MOUSE_RELEASED,(134,5636),absolute(247,293),button=3,modifiers=Meta+Button3,extModifiers=Meta,clickCount=1] on nav-DatabaseNavigatorWindow.Default, ObjectAction.CONN_NAME=IdeConnections%23dom, ObjectAction.DBOBJECT=oracle.dbtools.raptor.utils.DBObject@14744ca2, Context.VIEW=DatabaseNavigatorWindow.Default, Context.SELECTION=[Loracle.ide.model.Element;@2eec852d}]
INFO 1751 2041 oracle.dbtools.raptor.dialogs.BasicObjectModifier Finding Context Menu for:Oracle#TABLE:SEGMENT_BCKUP