Link to home
Start Free TrialLog in
Avatar of imran_fast
imran_fast

asked on

export error


Question:
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small

The above error is related to rollback segement and retention period but my question is

if i receive this error during export what about the dump file will it contain the data or it is currupted.
ASKER CERTIFIED SOLUTION
Avatar of ramumorla
ramumorla
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of imran_fast
imran_fast

ASKER

i cannot regenerate export file because the data is currupted.
Can i import part of table from the export file. can you provide me with the syntax.
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial