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
Tablespace
How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause
Generated DDL from tools may not be executable sometimes. I got ORA-02494 when I execute DDL scripts that were generated from other database by TOAD,… Read More »How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause
How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace
ORA-23515 I got this error when I was trying to drop a tablespace with all options. SQL> drop tablespace example including contents and datafiles cascade… Read More »How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace
How to Check Oracle Tablespace Usage
After having the whole picture about the size of the database, we can further check Oracle tablespace usage solely by SQL. Oracle Tablespace Usage Of… Read More »How to Check Oracle Tablespace Usage