SQL>Select owner,segment_name,segment_type from dba_extents where file_id=F> and B> between block_id and block_id+blocks-1;(F>和B>分別是ORA-01578報出的壞塊出現(xiàn)的文件號和塊號)
Cause:The given data block was corrupted,probably due to program errors
Action:Try to restore the segment containing the given data block,This may involve dropping the segment and recreating it,If there is a trace file,report the messages recorded in it to customer support.
ORA-01628:max # of extents num reached for rollback segment num
ORA-1628:max # extents 50 reached for rollback segment RBS_1
相應的英文如下：
Cause: An attempt was made to extend a rollback segment that already has reached its maximum size or space could not be allocated in the data dictionary to contain the definition of the object.
Action:If possible,increase the value of either the MAXEXTENTS or PCTINCREASE initialization parameters or find the data dictionary table lacking space and alter the storage parameters,as described in the Oracle8 Server Administrator's Guide.
