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!

Shrink tables

vpolasaApr 7 2014 — edited Apr 7 2014

Hi,

I would like to run a procedure, which I can execute once every week to find all the tables in a schema to shrink.

Below are the steps I'm planning to achieve:

1. Find tables for a schema that have fragmented free space.

2. Using a cursor loop shrink the tables.

Can someone please help me with this?

Thanks.

I'm using:

OS: Windows 7

DB:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

PL/SQL Release 11.1.0.7.0 - Production

CORE 11.1.0.7.0 Production

TNS for Linux: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 - Production

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2014

Added on Apr 7 2014

5 comments

2,655 views