Database Utilities (MOSC)

MOSC Banner

EXP db error ORA-02354: error in exporting/importing data

edited Sep 14, 2013 2:30AM in Database Utilities (MOSC) 13 commentsAnswered ✓

Hi All,

when i export the database using the expdb the few tables are failed to export, there are about 37 errors in the export logs similar to the below error

Error from the export Log

RA-31693: Table data object "test"."PRODUCT" 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 5 with name "_SYSSMU5_80241760$" too small
error in the alert log:

ORA-01555 caused by SQL statement below (SQL ID: 5wztymmx1ww87, SCN: 0x0000.47154a01):
SELECT * FROM RELATIONAL("test"."PRODUCT")

I did a quick search but most of my searches including the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center