BEGIN
for i in (select 'drop ' || object_type || ' SCHEMA_OWNER.' || object_name as stmt
from all_objects
where object_type in ('PACKAGE') and owner = 'SCHEMA_OWNER') loop
execute immediate i.stmt;
end loop;
end;
/
BEGIN
for i in (select 'drop ' || object_type || ' SCHEMA_OWNER.' || object_name || ' Cascade constraints purge' as stmt
from all_objects
where object_type in ('TABLE') and owner = 'SCHEMA_OWNER') loop
execute immediate i.stmt;
end loop;
END;
/
BEGIN
for i in (select 'drop ' || object_type || ' SCHEMA_OWNER.' || object_name || ' force' as stmt
from all_objects
where object_type in ('TYPE') and owner = 'SCHEMA_OWNER' ) loop
execute immediate i.stmt;
end loop;
end;
/
BEGIN
for i in (select 'drop ' || object_type || ' SCHEMA_OWNER.' || object_name as stmt
from all_objects
where object_type in ('SEQUENCE') and owner = 'SCHEMA_OWNER' ) loop
execute immediate i.stmt;
end loop;
END;
/
No comments:
Post a Comment