Snapshot too old error while taking expdp of table with lobsegment(BLOB) of 580 GB.
Strange observation : Before the export, 8 new undo datafiles of 1G each, autoextend on maxsize 10g were added to an existing undo tablespace of 40G, the expdp failed with snapshot too old, however none of the added datafiles were extended by even a byte. All stayed at 1G!
Why did the datafiles not extend/or tried to extend before giving error for snapshot too old? Also, how to make this exp successful?
Kindly assist here, Thanks in advance.