wxh \OracleDBA新手经常碰到的10个Oracle错

经验共享：OracleDBA新手经常碰到的10个Oracle错误
                        作者:servernet
                        查看论坛原文请点击这里
                        OracleDBA新手经常碰到的10个Oracle错误（英文）

                        This document contains information about errors 
                        frequently encountered by new DBAs, along with 
                        appropriate actions to be taken in each circumstance. 

                        +==+ 

                        Summary: 
                        10 COMMON RDBMS ERRORS 

                        +=+ 

                        1) ORA-1547 

                        a) on Rollback segment when importing. 

                        Specify commit=y and a large buffer on import. This way 
                        the Rollback will be released after each array, as 
                        opposed to each object. 

                        b) when allocating an extent on a tablespace with alot 
                        of free space. 

                        Select max(blocks) from DBA_FREE_SPACE. You may have 
                        free space but it might not be contiguous. Make sure it 
                        is greater than the extent it is trying to allocate. You