DATAFILE

How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

by Ed Chen
June 14, 2023June 24, 2023

RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »

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 Rename DataFile

by Ed Chen
October 18, 2022April 28, 2023

Rename DataFile The procedure of renaming an Oracle datafile is actually the same as the procedure of moving datafile with a different file name. Let's… Read More »

How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

by Ed Chen
September 5, 2022February 12, 2023

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 »

Create Tablespace Examples

by Ed Chen
August 22, 2022February 12, 2023

Creating a normal and permanent tablespace is pretty regular practice for a DBA whenever application needs it, comparing to creating a temporary tablespace. In this… Read More »

How to Resolve ORA-02180: invalid option for CREATE TABLESPACE

by Ed Chen
May 19, 2022February 12, 2023

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 Move Oracle Database

by Ed Chen
January 23, 2019May 31, 2023

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...

by Ed Chen
May 4, 2016March 29, 2018

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 »

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