Database Administration (MOSC)

MOSC Banner

Tablespace and table reorganization

edited Jan 29, 2010 3:41AM in Database Administration (MOSC) 5 commentsAnswered
 Hi Everyone,
I performed an online table reorganization and a tablespace reorganization(one after the other was stopped), but both jobs were not finishing for days. I stopped them. Now I noticed that there are some new objects(with strange names which I don't recognize) in the reorganized tablespace. I suspect that these are intermediate objects created automatically to facilitate the reorganization. What happens if I delete the stopped job? how do I even verify that they are indeed such intermediate objects?

Thanks.
Yinhai

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