Database Administrator
Showing posts with label
temporary tablespace
.
Show all posts
Showing posts with label
temporary tablespace
.
Show all posts
Thursday, October 18, 2012
Temporary Tablespace Related Scripts
›
To check instance-wise total allocated, total used TEMP for both rac and non-rac set lines 152 col FreeSpaceGB format 999.999 col U...
Monday, January 2, 2012
ORA-01114: IO error writing block to file 202 (block # 1473756)
›
Linux-x86_64 Error: 25: Inappropriate ioctl for device ERROR at line 29: ORA-01114: IO error writing block to file 202 (block # 1473756) ORA...
Saturday, December 24, 2011
ORA-01114: IO error writing block to file 201 (block # 763489) ORA-27072: I/O error Linux Error: 28: No space left on device
›
Event Insert data into table Error ERROR at line 25: ORA-01114: IO error writing block to file 201 (block # 763489) ORA-27072: File I/O erro...
Create / Clear Temporary tablespace
›
1) CREATE TEMPORARY TABLESPACE temp2 TEMPFILE 'E:\SNSD1011\TEMP02.ORA' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT ...
›
Home
View web version