set pagesize 2000 define schema_owner=JOVE','USER01','USER02','USER03
select 'ALTER TABLE '||owner||'.'||table_name||' DISABLE CONSTRAINT '||constraint_name||';' from dba_constraints where constraint_type = 'R' and delete_rule = 'CASCADE' and owner in ('&schema_owner');
select owner,constraint_name,constraint_type,status from dba_constraints where constraint_type='R' and status = 'ENABLED' and owner in ('&schema_owner');
select 'ALTER TABLE '||owner||'.'||table_name||' DISABLE CONSTRAINT '||constraint_name||';' from dba_constraints where constraint_type = 'C' and owner in ('&schema_owner');
select owner,constraint_name,constraint_type,status from dba_constraints where constraint_type='C' and status = 'ENABLED' and owner in ('&schema_owner');
select 'ALTER TRIGGER '||owner||'.'||object_name||' disable;' from dba_objects where object_type='TRIGGER' and owner in ('&schema_owner');
select distinct status from dba_triggers where owner in ('&schema_owner');
select job,next_date,next_sec,failures,broken from dba_jobs where schema_user in ('&schema_owner');
begin sys.dbms_job.broken(job=>21,broken=>true); commit; end; /
select owner,job_name,state,enabled,next_run_date,comments from dba_scheduler_jobs where owner in ('&schema_owner'); select 'execute dbms_scheduler.disable(''' || owner || '.' || job_name || ''');' from dba_scheduler_jobs where owner in ('&schema_owner');
select job,log_user,priv_user,schema_user,broken from dba_jobs where schema_user in ('&schema_owner'); select owner,job_name,state from dba_scheduler_jobs where owner in ('&schema_owner');
select t1.status,t1.validated,t2.status,t1.constraint_name,t1.owner from dba_constraints t1, dba_objects t2 where t2.object_name=t1.constraint_name and t1.owner in ('&schema_owner');
|