We have 9.2.0.8 database environment where an export dump is taken from the production database and is imported in to the reporting database.The import was taking huge time to complete so we decided do use COMMIT=N to reduce the import time by increasing the size of UNDO tablespace.. We increased the size of the UNDO tablespace to slightly greater than the largest table size, still failed with error :
IMP-00058: ORACLE error 30036 encountered
ORA-30036: unable to extend segment by XX in undo tablespace 'UNDOTS'
IMP-00028: partial import of previous table rolled back: XXXXX rows rolled back
Please advise if I missed out on some thing. What is the correct logic to arrive at the required UNDO size in such scenario. Thanks.