We are trying to export the Teamcenter database at our location and we are getting the below error. ---------error message----------------- ORA-31693: Table data object "INFODBA"."PDATA_0" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old --------------END-------------------
Speaking with our DBA experts this error seems to be related to UNDO segment and they suggested the below steps, but it still fails. While they analyze the next steps, thought can check if anyone has any other leads on this:
Connect as sys user in database;
Run the below commands (does not need DB restart and should not have any impact as we are just increasing the value):
show parameter undo; (By default it seems it would be around 900)
alter system set undo_retention = 2400 scope = BOTH; (Sets this value in both memory and Db file so that the parameter is taken up during restart of DB later)
3. Try Exporting only the failed table (no need for the entire database) to see if it succeeds.