Oracle Database Discussions

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!

Resizing initial extent

284059Jan 8 2008 — edited Aug 12 2008

HI Guys

Is there a way to resize the initial extent of a table without dropping and recreating by changing the INITIAL parameter? Is there a kind of package or something available?

We have lot of tables with initial size is quite big as they were defined in production. Unable to change the initial parameter when the tables are imported from prod. The dump is exported with COMPRESS=N and ROWS=N.

Appreciate your help.

Regards
Bhaskara

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2008

Added on Jan 8 2008

#general-database-discussions

13 comments

17,298 views