How to view the tablespaces in the current database?

Question Posted / sushma chaudhary

How to view the tablespaces in the current database?..

Answer / Shashank Pandey

To view the tablespaces in the current database, run the following query:

```plsql
SELECT table_name, tablespace_name FROM dba_tablespaces;
```

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

various types of hints and their usage

Where are the settings stored for each instance in oracle?

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

Explain the use of indexes option in imp command.

What is logical backup in oracle?

What are the logical operations?

what are Triggers?

What are the differences between char and nchar in oracle?

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

How to load data through external tables?

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

What is format trigger?

For more Oracle General Interview Questions Click Here