ORA-01114, ORA-27067 error solution-mysql tutorial

This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.

This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.

This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.

Today a friend asked the following case, ORA-01114, ORA-27067 and OSD-04026 errors at the same time:

* ** Action name :() 09:31:00. 762
* ** Module name :( JDBC Thin Client) 09:31:00. 762
* ** Service name :( SYS $ USERS) 09:31:00. 762
* ** Session id: (145.9) 09:31:00. 762
* ** 09:31:00. 762
Ksedmp: internal or fatal error
ORA-01114: IO error when writing block to file 201 (Block #492)
ORA-27067: the size of the I/O buffer is invalid
OSD-04026: Invalid parameter passed. (operating system 1318912)
ORA-01114: IO error when writing block to file 201 (Block #492)
ORA-27067: the size of the I/O buffer is invalid
OSD-04026: Invalid parameter passed. (operating system 1318912)
ORA-01114: IO error when writing block to file 201 (Block #492)
ORA-27067: the size of the I/O buffer is invalid
OSD-04026: Invalid parameter passed. (operating system 1318912)
ORA-01114: IO error when writing block to file 201 (Block #9)
ORA-27067: the size of the I/O buffer is invalid
OSD-04026: Invalid parameter passed. (operating system 1318912)
No current SQL statement being executed.

In some 9i versions, this error occurs because the file size exceeds the OS limit, most of which occur on Windows platforms.

Notes: 317174.1 on Metalink records a similar problem. this is a Bug in Oracle Server-Enterprise Edition-Version: 9.2.0.1.0 Microsoft Windows (32-bit:
Its a Bug specific to NT platform only. Cannot AUTOEXTEND to 4 Gb boundary, This bug is fixed in 9203.
317174.1 the error information recorded is as follows:

ORA-283: recovery session canceled due to errors
ORA-1115: IO error reading block from file 11 (block #204802)
ORA-1110: data file 11: 'E: ORACLEORA92BORGMAXIMO. ORA'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-4026: Invalid parameter passed. (operating system-204802)

However, the database is 10.2.0.4 on 64-bit Windows, and the problem occurs in the temporary tablespace file.

The causes of several related queries are similar: exceptions caused by CTAS processing large volumes of data.

In this Case, the ctas SQL has more than 600 cases When judgment, and the SQL text has 47 K. It is strongly recommended that you rewrite the SQL.