by Christopher Chelladurai – The following script lists all the tablespace names in the database with their type (whether permanent or temporary), extent management (whether local or dictionary), sizes, and status (online, offline, read-only). This script should be run by a DBA user in SQL*Plus.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help