Database Tuning (MOSC)

MOSC Banner

Problem with Reorganizing tablespaces with Enterprise Manager

edited Mar 5, 2010 1:37PM in Database Tuning (MOSC) 11 commentsAnswered
   Hello,

 

We are in the process of moving a very large amount of data from our development databases.  The business has decided that it does not need as much as data in development as it does in Production.  We have already deleted all the data, and now in the process of actually reclaiming that space.  I have been using Oracle's Segment Advisor to identify what tablespaces we can reclaim space in, and then running the recommended process to shrink the tablespace and it's associated files.  This is often in the form or reorganizing sub partitions and indexes.  However, once I reorganize the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center