(An Untitled Masterwork)
ActivePublic
Actions

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;

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

(An Untitled Masterwork)ActivePublicActions