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 to Resolve ORA-01135: file accessed for DML/query is offline
ORA-25139 Tried to create a temporary tablespace, but it failed with ORA-25139. SQL> create temporary tablespace temp1 datafile '/u01/app/oracle/oradata/ORCL/temp1_01.dbf' size 10m autoextend on next 10m… Read More »How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
ORA-02180 There're 2 basic patterns of error ORA-02180 in this post: Missing Tablespace Name Missing Keyword A. Missing Tablespace Name If we didn't specifiy the… Read More »How to Resolve ORA-02180: invalid option for CREATE TABLESPACE
According to SQL syntax of Oracle database, you can't resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but… Read More »You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...