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, 2062🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...