Data File

How to Resolve DBT-06006: Unable to create directory

by Ed Chen
March 15, 2023March 16, 2023

DBT-06006 Saw error DBT-06006 when we tried to create a database by Database Configuration Assistant (DBCA). [FATAL] [DBT-06006] Unable to create directory: (/oradata/ORCLCDB/). CAUSE:… Read More »

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… 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 to Resolve ORA-01157: cannot identify/lock data file

by Ed Chen
July 27, 2022December 17, 2022

ORA-01157 Saw error ORA-01157 when we tried to bring a tablespace online. SQL> alter tablespace example online; alter tablespace example online * ERROR at line… Read More »

What Can We See in a Normal Data File

by Ed Chen
October 30, 2019December 10, 2022

You might think that the content of a normal data file should be unrecognized binary text and we cannot really see it except using special… Read More »

How Max a Table Can Be

by Ed Chen
October 12, 2019December 10, 2022

Maximum Size Limit of a Table According to Oracle Logical Database Limits, tables can have at most 1000 columns and no limit on rows and… Read More »

How Max a Database Can Be

by Ed Chen
October 9, 2019December 10, 2022

Maximum Size Limit of a Database After knowing how big a data file can be and how big a tablespace can be in previous posts,… Read More »

How Max a Tablespace Can Be

by Ed Chen
October 5, 2019December 10, 2022

Tablespace Max Size Basically, at least one data file should be specified in the tablespace creation, thereafter we can add more data files to the… Read More »

How RMAN Restore Database from BackupSet

by Ed Chen
October 31, 2018December 10, 2022

In this post, I will show you how to restore a single-instance database from a backup set by RMAN. For RAC restoration, you may check… Read More »

How to Check Oracle Data Files Healthy

by Ed Chen
October 30, 2016October 2, 2019

Two ways that you can verify data files, one is using Oracle utility dbverify, the other is RMAN command.DbverifyWe can use dbv to check specific… Read More »