Oracle Database Discussions

Hi gurus,

The Scenario:* I have an Oracle Database 10.2.0.2 Enterprise Edition 64bits. This is a database of SAP System.

Parameters of Database:

sga_target = 0
sga_max_size = 8G
shared_pool_size = 1G
The Shared Pool has free space.

The Problem:* I have reorganized a table X two weeks ago fine. Yesterday I reorganized the same table with the same process but in the step when this process creates an index on the temporal table the process hang with the event Library cache lock for more of 8 hours, so I cancelled the process manually. As I had forced the cancellation of the proccess, I executed the cleanup process, and the process hang again in the same event.
Now the process is in this step:

BEGIN
   DBMS_REDEFINITION.abort_redef_table (uname           => '"SAPR3"',
                                        orig_table      => '"MSEG"',
                                        int_table       => '"MSEG#$"'
                                       );
END;

I hope that anybody can help me, because I am worried.

Thanks in advanced.