Collections:
Show All Tablespaces in the Current Database in Oracle
How To View Tablespaces in the Current Database in Oracle?
✍: FYIcenter.com
If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example:
SQL> connect SYSTEM/fyicenter Connected. SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS 2 FROM USER_TABLESPACES; TABLESPACE_NAME STATUS CONTENTS ------------------------------ --------- --------- SYSTEM ONLINE PERMANENT UNDO ONLINE UNDO SYSAUX ONLINE PERMANENT TEMP ONLINE TEMPORARY USERS ONLINE PERMANENT
⇒ Built-in Tablespaces in a Database in Oracle
⇐ Relation between Database and Tablespaces in Oracle
2019-01-20, 2296🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...