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 Big 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 Big a Table Can Be
How Big 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 Big a Database Can Be
How Big 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 Big a Tablespace Can Be
How RMAN Restore Database by a Backup Set
Suppose we have restored the whole OS to the new server including Oracle software and directory structure. Our goal is to restore the database to… Read More »How RMAN Restore Database by a Backup Set
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