EXP-00056: ORACLE error 1555 encountered
Window server 2003 32bit
Enterprise Edition Release 9.2.0.1.0 - Production
****************************************************************
I have exported schema dump successively regularly, one day we run the online exam
Student post large data(text) in exam.
and Database stop responding for specific tool in the application.
after this
I exported my schema successfully, just one table could not exported. this is the table where student data stored.
i checked the log file and found the following error
**EXP-00056: ORACLE error 1555 encountered**
**ORA-01555: snapshot too old: rollback segment number with name "" too small**
**ORA-22924: snapshot too old**
then i try to export this single table using following script
exp system/pass@orcl205 FIlE=SAM_ITEMGRADING_T.dmp log=SAM_ITEMGRADING_T.log TABLES=SAM_ITEMGRADING_T
Found this error
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table SAM_ITEMGRADING_T
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
Export terminated successfully with warnings.
Following is the script of the table
CREATE TABLE "SLATEEXAM"."SAM_ITEMGRADING_T"
(
"ITEMGRADINGID" NUMBER(19,0) NOT NULL ENABLE,
"ASSESSMENTGRADINGID" NUMBER(19,0) NOT NULL ENABLE,
"PUBLISHEDITEMID" NUMBER(19,0) NOT NULL ENABLE,
"PUBLISHEDITEMTEXTID" NUMBER(19,0) NOT NULL ENABLE,
"AGENTID" VARCHAR2(255 CHAR) NOT NULL ENABLE,
"SUBMITTEDDATE" TIMESTAMP (6),
"PUBLISHEDANSWERID" NUMBER(19,0),
"RATIONALE" VARCHAR2(4000 CHAR),
"AUTOSCORE" FLOAT(126),
"OVERRIDESCORE" FLOAT(126),
"COMMENTS" VARCHAR2(4000 CHAR),
"GRADEDBY" VARCHAR2(255 CHAR),
"GRADEDDATE" TIMESTAMP (6),
"REVIEW" NUMBER(1,0),
"ATTEMPTSREMAINING" NUMBER(10,0),
"LASTDURATION" VARCHAR2(36 CHAR),
"ANSWERTEXT" CLOB,
CONSTRAINT "FKB68E675667B430D5" FOREIGN KEY ("ASSESSMENTGRADINGID") REFERENCES "SLATEEXAM"."SAM_ASSESSMENTGRADING_T" ("ASSESSMENTGRADINGID") ENABLE
)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "NUTES" LOB
(
"ANSWERTEXT"
)
STORE AS BASICFILE
(
TABLESPACE "NUTES" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
) ;
CREATE UNIQUE INDEX "SLATEEXAM"."SYS_IL0000093338C00017$$" ON "SLATEEXAM"."SAM_ITEMGRADING_T"
(
PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "NUTES" PARALLEL (DEGREE 0 INSTANCES 0) ;
the total no. of rows in table are 549576
Can you plz help me how to export this table.
also suggest me what changes required so that our database does not stop responding while taking exam.