Find in this Blog

Sunday, April 14, 2019

CLONING ERRORS and RETURN CODE in DBCLONE01


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 ?#