~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.GED
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'DYNPSOURCE~' AND INDEXNAME = '0'
3 ETGCLN ALTER TABLE "DYNPSOURCE~" MODIFY LOB ("FIELDINFO") (CACHE)
3 ETGCLN ALTER TABLE "DYNPSOURCE~" MODIFY LOB ("LOGICINFO") (CACHE)
3 ETGCLN ALTER TABLE "DYNPSOURCE~" MODIFY LOB ("EXTENSIONS") (CACHE)
3 ETGCLN insert /*+APPEND */ into "DYNPSOURCE~" ( "PROGNAME", "DYNPNUMBER", "R3STATE", "FIELDINFO", "LOGICINFO", "EXTENSIONS" ) select /*+PARALLEL( DYNPSOURCE )*/ "PROGNAME", "DYNPNUMBER", "R3STATE", "FIELDINFO", "LOGICINFO", "EXTENSIONS" from "DYNPSOURCE"
1EETGCLN ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
1EETGCLN DYNPSOURCE
1EETGCLN Error copying table data
1
Solution:
increase the Undo_retion parameter value
also increase SAPUNDO table space
No comments:
Post a Comment
Ask Your Questions ?#