记录一次EXPDP导出ORA-01555报错
遇到ORA-01555报错最直接的反应就是undo表空间大小是否足够，undo_retention参数是否设置太小
经过验证，均不是以上问题造成的，经过查看表结构发现该表格含有BLOB字段
SQL> desc SZBOXTICKET.TICKETINFO
Name Null? Type
----------------------------------------- -------- ----------------------------
CHIPINID NUMBER(22)
TEMPID NUMBER(22)
SERIALNO VARCHAR2(2000)
CHIPINTYPE NUMBER(22)
GAMECODE NUMBER(22)
MANNER VARCHAR2(10)
CHIPINNUMS VARCHAR2(2000)
STATUS NUMBER(5)
RECORD NUMBER(5)
MULTIPLE VARCHAR2(200)
BETS NUMBER(5)
AWARDBETS NUMBER(22,2)
TEMPAWARDBETS NUMBER(22,2)
TEMPINFO VARCHAR2(200)
TAXAWARDBETS NUMBER(22,2)
USERID NUMBER(5)
USERNICKNAME VARCHAR2(2000)
RECORDID NUMBER(5)
CONDITION VARCHAR2(200)
VOTEPROCCESSTIME NUMBER(24)
LOGINNAME VARCHAR2(50)
SPVALUE VARCHAR2(4000)
ISPRINT NUMBER(5)
ISCOUNTAWARD NUMBER(5)
HUSERCOUNT NUMBER(5)
ISSUE VARCHAR2(50)
TICKETID VARCHAR2(100)
TICKETIMAGE BLOB
STRPASSWORD VARCHAR2(50)
PSDCHECK VARCHAR2(50)
BLACKMARK VARCHAR2(400)
PRINTSERVICENUMBER VARCHAR2(40)
POSTCOUNT NUMBER
PRINTLATERTIME NUMBER(24)
TICKETAWARD NUMBER(5)
AWARDPOSTCOUNT NUMBER(5)
AWARDSERVICENUMBER VARCHAR2(100)
POSTTIME NUMBER(24)
AWARDPOSTTIME NUMBER(24)
POSTSTATUS NUMBER(5)
AWARDPOSTSTATUS NUMBER(5)
LASTSCREENINGTIME NUMBER(24)
FROMSERIALNO VARCHAR2(2000)
SENDPRINTTIME NUMBER(24)
LOTTERYTYPE VARCHAR2(100)
EXCEPTIONINFO VARCHAR2(200)
PRIORTICKETAWARD NUMBER(2)
