234: /*
235: -- Initial Enqueue only if no Sequential process is running.
236: SELECT COUNT(1)
237: INTO l_cnt
238: FROM v$session
239: WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
240: AND status <> 'KILLED';
241: if l_cnt > 0 then
242: l_enqueue := 'N';
353: WHEN OTHERS THEN
354: if p_exec_mode = 'P' then
355: SELECT COUNT(1)
356: INTO l_cnt
357: FROM v$session
358: WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
359: AND status <> 'KILLED';
360: if l_cnt = 0 then
361: if sqlcode = -25228 then
881: where object_type IN ('ENABLE_TRIGGER', 'ENABLE_CONSTRAINT', 'START_QUEUE', 'ENABLE_POLICY');
882:
883: cursor proc_csr IS
884: select 1
885: from v$session
886: /* where module in ('TS_MIGRATE_SEQUENTIAL_OBJECTS', 'TS_MIGRATE_PARALLEL_OBJECTS') */
887: where module in
888: ('TS_MIGRATE_SEQUENTIAL_OBJECTS',
889: 'TS_MIGRATE_PARALLEL_OBJECTS',