Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\lib\int\oracle\sysman\vdd\VddSQL.class

??���/�*
���� �s_sqlRetrieveRows�Ljava/lang/String;�
ConstantValue�!�s_releaseOwner�"�s_sqlInsertOperation�#�s_sqlDeleteOperation�$�s_sqlUpdateOperation�%�
s_sqlQuerySMP�&�s_sqlReleaseBlockedOps�'�
s_faultString�(�s_updateString�)�<init>�()V�Code�LineNumberTable�
SourceFile�VddSQL.java���oracle/sysman/vdd/VddSQL�java/lang/ObjectASELECT /*+ ORDERED NO_MERGE */ o.rowid, o.request_id, o.request_subtype,        o.request_type, o.target, o.node, o.user_name, o.callback  FROM (SELECT optbl.sequence_num        FROM SMP_VDD_OPERATIONS_TABLE optbl        WHERE optbl.owner='OP_UNALLOCATED' AND              ( ( optbl.outgoing = 'Y' AND                  ( optbl.node IN                    (SELECT  node_rgn_map.node                     FROM SMP_VDP_NODES node_rgn_map,                          SMP_VDP_NODE_INFO_VDD  node_info,                          SMP_VDP_OMS_REGION_MAP oms_rgn_map                     WHERE node_rgn_map.region_name =                               oms_rgn_map.region_name AND                           node_rgn_map.node = node_info.node AND                           node_info.status != 'N' AND                           oms_rgn_map.oms = ?                    )                  )                ) OR                ( optbl.outgoing = 'P' AND                  ( optbl.node IN                    (SELECT pgsrv_rgn_map.paging_server                     FROM SMP_VDP_PGSRV_REGION_MAP pgsrv_rgn_map,                          SMP_VDP_OMS_REGION_MAP oms_rgn_map                     WHERE pgsrv_rgn_map.region_name =                               oms_rgn_map.region_name  AND                           oms_rgn_map.oms = ?                    )                  )                ) OR                (%s) OR                (optbl.outgoing = 'N')              )        GROUP BY optbl.sequence_num) v,       SMP_VDD_OPERATIONS_TABLE o  WHERE o.sequence_num=v.sequence_num AND        rownum <= ?  FOR UPDATE OF o.sequence_num �Rupdate SMP_VDD_OPERATIONS_TABLE set owner = 'OP_UNALLOCATED' where rowid IN ( %s )insert into SMP_VDD_OPERATIONS_TABLE (request_id, request_subtype, request_type, target, node, user_name, callback, timestamp, outgoing, owner, sequence_num) select  ?, ?, ?, ?, ?, ?, ?, ?, ?, 'OP_UNALLOCATED', smp_vdd_op_seq.nextval from dual where rownum=1�4delete from SMP_VDD_OPERATIONS_TABLE where rowid = ?�Kupdate SMP_VDD_OPERATIONS_TABLE set owner= 'OP_UNALLOCATED' where rowid = ?�Qselect count(*) from sys.dba_tables where table_name = 'SMP_VDD_OPERATIONS_TABLE'�Kupdate SMP_VDD_OPERATIONS_TABLE set owner= 'OP_UNALLOCATED' where OWNER = ?�Mupdate SMP_VDD_OPERATIONS_TABLE set owner = 'OP_UNALLOCATED' where owner in (�>update SMP_VDD_OPERATIONS_TABLE set owner = ? where ROWID in (�1�����	������������������	��
����������������
�����������������������������������������������������������*?�?�����������1������

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de