Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

plsql block for compression of multi tables

rangapavanOct 19 2011 — edited Oct 20 2011
i have one user xxxxxx, he owned 65 tables, i want to compress all these tables at a time
any one can suggest the to write plsql block to compress all tables at a time

to compress one table "alter table table_name move compress"
This post has been answered by 32685 on Oct 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2011
Added on Oct 19 2011
8 comments
3,832 views