| Clean temp tablespace [message #55066] |
Wed, 01 January 2003 23:56  |
Sunil Rohit
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Hi all,
Our temp tablespace is full, i have also added new datafile in it but still
it is giving errors :
"ERROR at line 1:
ORA-01114: IO error writing block to file 4 (block # 524258)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 524258)
ORA-01114: IO error writing block to file 4 (block # 524258)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 524258)
"
Kindly help what to do?
How to reuse temp tablespace datafile once it is already created?
Pls. help us immediately.
|
|
|
|
| Re: Clean temp tablespace [message #55069 is a reply to message #55066] |
Thu, 02 January 2003 00:59  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
insteated of temp tablesspace u try to increae or add u r production tablespace. otherwise u please write how u added the datafile to temp tablespace
best wishes
|
|
|
|
|
|
| Re: Clean temp tablespace [message #55088 is a reply to message #55066] |
Thu, 02 January 2003 13:15 |
sharan alva
Messages: 57
Registered: November 1999
|
Member |
|
|
You can drop and recreate the temp tablespace and this shoudl be taken cares off. However, I had an issue with a datafile extending 4 gig in size.
The following query will give you the size of the datafile in your case it is file 4.
select file#, bytes, create_bytes from v$datafile;
The datafile has to be made smaller than 4Gb, by dropping the tablespace and
recreating the content of the tablespace in datafiles smaller than 4Gb.
Avoid datafiles with autoextend enabled as they might extend to 4Gb or beyond.
Example:
SQL> select tablespace_name
from dba_data_files
where file_id=<file_number> mentioned in ORA-01114 and ORA-027069
SQL> select contents from dba_tablespaces where tablespace_name=
<name_of_the_tablespace>; => temporary
As the datafile belongs to a temporary tablespace you can drop and recreate it with datafiles smaller than 4Gb. Do not use AUTOEXTEND unless in combination with MAXSIZE.
In other cases it might be wise to secure the data of the tablespace first in order to be able to recreate it.
Hope this helps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
