Narayana Tutorial

Online Java Tutorial Blog

Tag: tablespace

How to get the Tablespace details in Oracle

oracle

This article helps you to get more information about Tablespace in Oracle along with a few commands which helps in your day to day activity. How to get the list of available Tablespaces SQL> select tablespace_name, sum(bytes)/power(1024,2), sum(maxbytes)/power(1024,2), AUTOEXTENSIBLE from dba_data_files group by tablespace_name, AUTOEXTENSIBLE; This list down all the tablespaces that are available in […]

Narayana Tutorial © 2018 Frontier Theme
Show Button
Hide Button