Page MenuHomePhabricator

(An Untitled Masterwork)
ActivePublic

Authored by stwalkerster on Aug 4 2016, 10:13 PM.
Tags
None
Referenced Files
F1427:
Aug 4 2016, 10:13 PM
Subscribers
None
declare
cursor c is
select table_name
from user_tables
where compression <> 'ENABLED';
r c%ROWTYPE;
begin
for r in c loop;
execute immediate 'ALTER TABLE ' || r.table_name || ' MOVE COMPRESS';
end loop;
end;

Event Timeline

import-bot changed the edit policy from "All Users" to "Community (Project)".Feb 3 2017, 3:03 PM