考试网 >> IT认证 >> Oracle >> Oracle指导 >> DBA经常遇到的10个错误

发布时间：2006-06-28 09:40     点击：

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 can reduce the storage parameters NEXT and

        PCTINCREASE if it isn't.

 

2)  ORA-1556 max extents of 121 exceeded when storage is set for maxextents

     of 999.

 

     Most platforms have a max of 121 even though it allows you to specify

     999.  (see the readme for your platform)

 

3)  ORA-1090 shutdown in progress when starting up even after a shutdown was

     issued quite some time ago.

 

     If the background processes aren't running the SGA could have been left

     out there... Issue a startup force open (which does a shutdown abort

     first).

 

4)  IMP-0003, ORA-942 and IMP-00023 on import.

 

     Run catalog.sql and expvew.sql (renamed catexp.sql in v7) as sys before

发表评论： 匿名发表 用户名: 查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任 留言板管理人员有权保留或删除其管辖留言中的任意内容 本站提醒：不要进行人身攻击。谢谢配合。