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