No One
Actions

Authored By

	stwalkerster
	Aug 4 2016, 10:13 PM

Size

227 B

Referenced Files

None

Subscribers

None

View Options

	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;

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1215
Default Alt Text: (227 B)

Event Timeline