What are the common Import/ Export problems?
ORA-00001: Unique constraint (…) violated – You are importing duplicate rows. Use IGNORE=NO to skip tables that already exist (imp will give an error if the object is re-created). ORA-01555: Snapshot too old – Ask your users to STOP working while you are exporting or use parameter CONSISTENT=NO ORA-01562: Failed to extend rollback segment – Create bigger rollback segments or set parameter COMMIT=Y while importing IMP-00015: Statement failed … object already exists… – Use the IGNORE=Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.
ITPUB˿ռ)R#J R(g ^ k F ~9K ORA-00001: Unique constraint (…) violatedITPUB˿ռ)k m u \ p E You are importing duplicate rows. Use IGNORE=NO to skip tables that already exist (imp will give an error if the object is re-created). 4g#k t9] Z F.z T:^ D0ORA-01555: Snapshot too oldITPUB˿ռ#I }*I;}#B g h3l _&D&s Ask your users to STOP working while you are exporting or use parameter CONSISTENT=YESITPUB˿ռ:L4l*l n6y+b(G ORA-01562: Failed to extend rollback segment 0n w X c(u g9x q1K#`0Create bigger rollback segments or set parameter COMMIT=Y while importing /Q q `&d”P R I q0IMP-00015: Statement failed … object already exists…ITPUB˿ռ D l C h H u Use the IGNORE=Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.
