Re: Tablespace names

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/04/17
Message-ID: <390571c3.42070353@netnews.worldnet.att.net>#1/1

Each tablespace name must be unique. If you're logged in as SYSTEM, you can query DBA_TABLESPACES for a list of tablespace names. Try this:

select tablespace_name from dba_tablespaces;

Each name will be unique. If your script is getting three rows back for one tablespace, you probably have an issue with your script. It may be returning one row for each free extent within that tablespace. Possibly. That's just the first thought that comes to my mind.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Sat, 15 Apr 2000 15:53:02 GMT, farrellyr5408_at_my-deja.com wrote:

>Is it possible to have more then one tablespace with the same name? I
>have just taking over a database at a place that hasn't had a DBA for
>awhile, so they are just looking for some monitoring and it is a good
>start for me. It looks like it has 3 tablespaces with the same name,
>is this possible? Maybe I need to fix the script that checks for free
>space, because it gives me 3 seperate values for 3 tablespaces with the
>same name.
Received on Mon Apr 17 2000 - 00:00:00 CDT