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, 4712🔥, 0💬
Popular Posts:
How To Connect to a MySQL Server with a Port Number in MySQL? If you want to connect a MySQL server ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...