Tablespace and table reorganization
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
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
0