CREATE OR REPLACE TYPE TT_NUMBER      AS TABLE OF NUMBER;

create table trader_acc_ino (
account_id   number,
wl_partner_id number,
status_id     number,
LAYOUT_TYPE_LIST tt_number
)
nested table LAYOUT_TYPE_LIST store as TRDR_ACCNT_NT_LTL1
 STORAGE ( INITIAL 64k )
partition by list (status_id)
subpartition by range (wl_partner_id)
subpartition template (   SUBPARTITION  TA_WLP_346                       values less than (347), 
    SUBPARTITION  TA_WLP_LS_973                    values less than (973),
    SUBPARTITION  TA_WLP_LS_975                    values less than (975),
    SUBPARTITION  TA_WLP_LS_976                    values less than (976),
    SUBPARTITION  TA_WLP_LS_977                    values less than (977),
    SUBPARTITION  TA_WLP_MAX                       values less than (MAXVALUE)
    ) 
(  partition ACT values (0, 1, 2, 3),
   partition INACT values (4)
 )
 enable row movement

declare
   p_cur  sys_refcursor;
begin
   rollback;
   open p_cur for
   select 
          (  SELECT 1 FROM trader_acc_ino WHERE ta.account_id = account_id AND ROWNUM <= 1)  as a3
    FROM    trader_acc_ino ta
    LEFT JOIN test_cust.trader_acc_ino acr ON ta.account_id = acr.account_id
    ;

   close p_cur ;
--  commit;
end; 

SELECT l.sid, lo.oracle_username, lo.locked_mode, l.ctime, o.object_id,
       o.owner, o.object_name, o.object_type
  FROM v$lock l, v$locked_object lo, dba_objects o
 WHERE     l.TYPE = 'TM'
       AND l.sid = lo.session_id
       AND l.id1 = lo.object_id
       AND lo.object_id = o.object_id
       AND o.temporary != 'Y'