Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P43
(An Untitled Masterwork)
Active
Public
Actions
Authored by
stwalkerster
on Aug 4 2016, 10:13 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Tags
None
Referenced Files
F1427:
Aug 4 2016, 10:13 PM
2016-08-04 22:13:06 (UTC+0)
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
stwalkerster
created this paste.
Aug 4 2016, 10:13 PM
2016-08-04 22:13:06 (UTC+0)
•
import-bot
changed the edit policy from "All Users" to "
Community
(Project)".
Feb 3 2017, 3:03 PM
2017-02-03 15:03:44 (UTC+0)
Log In to Comment