Analysis and Solution of Oracle Common Error Codes (1)

Oracle Frequently Assessment and Solution (1) In the process of using Oracle, we will often encounter some Oracle generated errors. For beginners, these errors may be a bit blurry, and I may not know how to deal with it. These mistakes, I have a more frequent error code in use, I hope to help you find a way to resolve these errors, and I hope that you can make your different opinions. After all, as a means of communication, personal opinion is inevitably too biased, and it must be inadequate, and there is a inevitable error. The purpose of writing this article is to promote and make progress together by mutual exchanges. ORA-01650: Unable to Extendback Segment Name By Num IntablesPACE NAME Cause: The above Oracle error is caused by insufficient rollback segment table space, which is also the most common Oracle error message for Oracle data administrators. When the user is doing a very large data operation, the existing return segment is low, which makes the above-described error in the split segment table space that can be allocated and cannot be assigned. Solution: Use the "Alter TableSpace TableSpace_name Add DataFile FileName Size_OF_FILE" command to add table space to the specified data, and can add one or more tablespaces depending on the specific case. Of course, this is related to the bare disk device on your host. If your host's bare disk device has no extra usage space, it is recommended that you don't intend to increase the size of the split table space, you can use the following statement first query first How much is the remaining TableSpace space: select user_name, SQL_Text from V $ Open_CURSOR WHERE User_name = ''; if the extra space is more, you can properly append a large returning segment to the table space, thereby avoiding the above mistake. You can also use the following statement to detect the competitive situation of Rollback Segment: SELECT CLAVS, Count From V $ WaitStat WHERE CALSS IN ('System undo header', 'undo header', 'undo block'); And SELECT SUM (Value) from V $ sysstat where name in ('CONSISTENTS'); if any Class in Count / SUM (Value) is greater than 1%, you should consider adding Rollback Segment. Corresponding English as follows: Cause: Failed to allocate extent from the rollback segment in tablespace Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace ORA-01652:. Unable to extend temp segment by num in tablespace Name Generative Cause: Oracle Temporary Table Space is insufficient, because Oracle always tries to allocate continuous space, and there is not enough assignable space or allocation discontinuitions.