- Permanent, undo, or temporary
- Smallfile or bigfile
SQL> SELECT TABLESPACE_NAME, CONTENTS, BIGFILE FROM DBA_TABLESPACES;
2. Run a query similar to the following to check if the autoextend feature is turned on, the current size of the datafile, and the maximum configured limit:
For Permanent and undo tablespaces: