Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace names
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.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
sounds like a bug in the SQL or a tablespace created with double-quotes around the name and trailing spaces...
I would suspect the former...
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Mon Apr 17 2000 - 00:00:00 CDT