Collections:
Show All Data Files in the Current Database in Oracle
How To View Data Files 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> col tablespace_name format a16; SQL> col file_name format a36; SQL> SELECT TABLESPACE_NAME, FILE_NAME, BYTES 2 FROM DBA_DATA_FILES; TABLESPACE_NAME FILE_NAME BYTES --------------- ------------------------------- --------- USERS \ORACLEXE\ORADATA\XE\USERS.DBF 104857600 SYSAUX \ORACLEXE\ORADATA\XE\SYSAUX.DBF 461373440 UNDO \ORACLEXE\ORADATA\XE\UNDO.DBF 94371840 SYSTEM \ORACLEXE\ORADATA\XE\SYSTEM.DBF 356515840
⇒ Create a New Data File in Oracle
⇐ Built-in Tablespaces in a Database in Oracle
2019-04-13, 8441🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...