How to view table space in oracle

Oracle method to view all table spaces: [select * from Dba_Tablespaces]. If you want to check the table space used by the current user, you can use the [select * from user_users] command.

Oracle database is a very easy-to-use relational database. Oracle data is maintained and stored in table space. The table space contains oracle data, structure and other information.

(Recommended learning: oracle tutorial)

If you want to check the table space used by the current user, use the following command:

select * from user_users

If you want to check For all table spaces under oracle, use the following command:

select * from Dba_Tablespaces

The information presented by this command includes the name of the table space and the size of the table space.

The above is the detailed content of How to view table space in oracle. For more information, please follow other related articles on the PHP Chinese website!