create table MAXVFILTER_CARD
(
  article VARCHAR2(10),
  audsid  NUMBER
)
  pctfree 10
  initrans 3
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  )
nologging;

create index IDX_MAXVFILTER_CARD_AUDSID on MAXVFILTER_CARD (AUDSID)
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

DELETE FROM MAXVFILTER_CARD T 
WHERE T.AUDSID IN 
 (SELECT F.AUDSID FROM MAXVFILTER_CARD F,V$SESSION G 
  WHERE G.AUDSID(+)=F.AUDSID AND G.AUDSID IS NULL AND F.AUDSID<>'30000000' AND F.AUDSID<>'30000001')

DELETE FROM MAXVFILTER_CARD T 
WHERE T.AUDSID IN 
   (SELECT DISTINCT F.AUDSID FROM MAXIMIZATOR.MAXVFILTER_CARD F,V$SESSION G 
    WHERE G.AUDSID(+)=F.AUDSID AND G.AUDSID IS NULL AND F.AUDSID<>'30000000' AND F.AUDSID<>'30000001')