Importing table structure hangs on forever

[dbasan]

When i impot the table structure with out rows hangs forever. I could see the segments and extents allocated, but export does not complete, it just hangs for hours.

[dbasan]

I could find a trigger is involved with the table and this trigger inserts data to the remote database through dblink on a Trasparent gateway to non-oracle db.

Does this has role in the import hang?

[reydp]

have you try disabling the trigger and constraints of the table b4 importing?

[dbasan]

There is no trigger available in the database at the time of import.

[dbasan]

After much of research i found the rollback segment is corrupt. How to resolve from the corrupt rollback? Have only export backups!!
This is oracle 9i R2 on solaris.

[LKBrwn_DBA]

Create another rollback (tablespace) and drop corrupt rollback (ts).

[dbasan]

Create another rollback (tablespace) and drop corrupt rollback (ts).

There is a locked remote query on the table which has corrupted the undo. unable to rollback the query as well purge. Let me try!

[ixion]

Try killing the remote querrry.
What oracle error is being generated?

[dbasan]

I killed the session.
no errors???

I can say the transaction is still in the rollback segment, which is corrupted. Need to purge the entries manually, then change the status of the query in the table to proceed further. Looking into workaround.

[dbasan]

Got this solved today, how?

Purged the entries manually, did a db restart that eventually cleared dictionary. Got the undo back as before.

Thanks all for your valuable suggestions and concerns.