What Can We See in a Normal Data File
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 »What Can We See in a Normal Data File
Data File
How Max a Table Can Be
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 Table Can Be
How Max a Database Can Be
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 Database Can Be
How Max a Tablespace Can Be
Maximum Size Limit of a Tablespace Basically, at least one data file should be specified in the tablespace creation, thereafter we can add more data… Read More »How Max a Tablespace Can Be
How RMAN Restore Database from BackupSet
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 RMAN Restore Database from BackupSet
How to Check Oracle Data Files Healthy
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 »How to Check Oracle Data Files Healthy
When Database is Not Consistent
There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… Read More »When Database is Not Consistent
How to Resolve ORA-01653 Unable to Extend Table in Tablespace
ORA-01653 The following two error messages are very similar. As a DBA, you'll probably meet them someday in the future. ORA-01653 is for table, ORA-01654… Read More »How to Resolve ORA-01653 Unable to Extend Table in Tablespace