SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


How To View the Tablespaces in the Current Database?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

Go down

How To View the Tablespaces in the Current Database? Empty How To View the Tablespaces in the Current Database?

Post by Micheal Tue Jan 19, 2010 7:13 pm

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 FROM USER_TABLESPACES;
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM ONLINE PERMANENT
UNDO ONLINE UNDO
SYSAUX ONLINE PERMANENT
TEMP ONLINE TEMPORARY
USERS ONLINE PERMANENT

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum