Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: QUestion: how to list all the tablespaces?
"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
Received on Wed Dec 15 2004 - 15:06:20 CST