ORA-01135

How to Resolve ORA-01135: file accessed for DML/query is offline

by Ed Chen
November 23, 2022December 12, 2022

ORA-01135 Some user reported an error ORA-01135 when querying the database. ORA-01135: file 1291 accessed for DML/query is offline ORA-01110: data file 1291: '/u01/app/oracle/oradata/orcl/users01.dbf' ORA-01135… Read More »

How Oracle Resize Temp Tablespace

by Ed Chen
July 28, 2021March 16, 2023

Resizing a temporary tablespace may have 2 meanings in Oracle, one is to increase its size, the other is to shrink its size. In this… Read More »

JavaScript is not enabled. Please enable it and reload the page.