EXP-00008 Solution

The following error occurs during exp,

EXP-00008: Oracle error 1555 occurred
ORA-01555: Snapshot too old: rollback segment number 52 with name "rbs51" too small
Export job terminated successfully with a warning

The solution found on the Internet is to increase the size of the rollback segment, but I have increased a lot and still report this error. it seems that the amount of data to be exported is too large. Try to export the data in multiple parts. Change the exp command to exp ITS/Its @ It tables = (barcode_info) file = (barcode2.dmp, barcode3.dmp, barcode4.dmp, barcode5.dmp, barcode7.dmp, barcode8.dmp, barcode9.dmp, barcode10.dmp, barcode11.dmp) filesize = 2000 m constraints = n buffer = 131072 recordlength = 64000 triggers = n log = logsfis. log indexes = n compress = n feedback = 1000 parfile1_exp.txt

Parfile.txt

Query = "where make_date between to_date ('1970-01-01 00:00:01 ', 'yyyy-mm-dd hh24: MI: ss ') and to_date ('1970-01-01 00:00:00 ', 'yyyy-mm-dd hh24: MI: ss ')"

In fact, problems still occur during the export process. After the direct = y is canceled, it will be normal. It is estimated that direct = y cannot coexist with query.