I'm trying to import a large database, and after a while I get:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
I know this has been asked before, but I can't find a clear answer other than "increase the size".
Tablespace is like this:
It's an autoextend, but that is meaningless since it can't grow past 32GB, therefore I can't "increase the size".
Does impdp try to do everything in one transaction?
I don't care what it's putting in UNDOTBS1, if I lost everything in there that would be fine, I just want the import to run successfully.
Can I flush it out?, Is there an impdp option that I can use to make it not crash after 2 hours of hoping it won't crash?
There is plenty of disk space.
Any advice appreciated