Get list of tablespaces

Category : Home > Databases > Oracle

SQL statement to get a list of all tablespaces in Oracle database:

SQL> select * from dba_tablespaces;

Options


Start discussion or add comment to this tip

Details

Tip reference : #214 views : 228	Added on : 10/08/08	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (172)


<< Previous Next >>

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Operating Systems > Unix : How to kill Unix user session
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Databases > Oracle : Kill user session

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Office Software \| TipLib FAQ