Re: QUestion: how to list all the tablespaces?

"Turkbear" <john.g_at_dot.spamfree.com> a écrit dans le message de news:tlc1s0tk9ighne76n90qs5kp72d8ng4b0h_at_4ax.com...
| "Michel Cadot" <micadot{at}altern{dot}org> wrote:
|
| >
| >"Grace Tsai" <gtsai_at_bnl.gov> a écrit dans le message de news:cpq0mt$jfo$1_at_news.bnl.gov...
| >| Hi,
| >|
| >| This is a really elementary question. What is the command to list all
| >| the tablespaces in the database? Thanks.
| >|
| >| Grace
| >|
| >
| >select tablespace_name from dba_tablespaces;
| >
| >Regards
| >Michel Cadot
| >
|
|
| OK, so do it the easy way...
|
| ;-)
|

We can also use user_tablespaces to to limit those on which we have access.

;-)
Michel Cadot Received on Wed Dec 15 2004 - 16:11:32 CST