Tablespace

How Big a Tablespace Can Be

Posted on
Add DataFile in a Tablespace
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 files to the tablespace. After knowing how big a data file can be in the previous post, we can continue to calculate how big a tablespace can be. For a […]
DDL

How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause

Posted on
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, a very popular administration tool used by DBA. Irrational DDL SQL> CREATE TABLESPACE PERSON DATAFILE   2    ‘/u02/app/oracle/oradata/datastore/.ACFS/snaps/orcl/ORCL/datafile/user01.dbf’ SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 4G   3  LOGGING […]
Tablespace

How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace

Posted on
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 constraints; drop tablespace example including contents and datafiles cascade constraints * ERROR at line 1: ORA-23515: materialized views and/or their indices exist in the tablespace Let’s see the content of […]
Tablespace

How to Check Oracle Tablespace Usage

Posted on
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 course, you can use GUI tools to check the space usage of tablespace in Oracle, but if someday, the only tool you got is sqlplus, a text-based tool, everything must […]