oracle常见错误代码的分析与解决（Analysis and solution of common error codes in Oracle）.docVIP

oracle常见错误代码的分析与解决（Analysis and solution of common error codes in Oracle） In the process of using ORACLE, we often encounter some ORACLE errors, for beginners, these errors may be fuzzy, but do not know how to deal with possible from these mistakes, I have used in relatively frequent error code made a analysis, hope to be able to help you find a reasonable solution the wrong way, and also hope you can put forward different views you. After all, as a means of communication, personal opinions are too biased, and there must be shortcomings, mistakes are unavoidable. The purpose of writing this article is to promote and make progress together through mutual communication. ORA-01650:unable, to, extend, rollback, segment, NAME, by, NUM, NAME, intablespace Causes: the above ORACLE error is caused by insufficient rollback table space, and this is also the most common ORACLE error message for ORACLE data administrators. These errors occur when a user makes a very large data operation that results in a shortage of existing rollback segments and enables the allocated rollback segment table space to be full and cannot be allocated again. Solution: the use of ALTER TABLESPACE tablespace_name ADD DATAFILE filename SIZE size_of_file command to add table space to the specified data, according to the specific circumstances can increase one or more table space. Of course, this also with you on a host of disc related equipment, if you host the bare disk device has no extra space, it is recommended that you do not lightly increase the rollback segment size, you can use the following statements to check the remaining tablespace how much space: Select, user_name, sql_text, from, V$open_cursor, where, user_name=; If more space is available, a large rollback segment can be added appropriately to the table space to avoid such errors. You can also use the following statement to test the competitive status of rollback segment: Select, class, count, from, V$waitstat, where, calss, in (` system