Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace names

Re: Tablespace names

From: Kari Pannila <Xkartsa_at_ougf.fi>
Date: 2000/04/17
Message-ID: <38FADE2D.FACE36DB@ougf.fi>#1/1

roblop wrote:

> Hmmm... i think that Oracl'e uses numeric value to identify tablespace. So
> two tablespace with the same name is acceptable. A trouble is do it. But I
> think that is possible.
>
> Roblop

You should first drop data dictionary index I_TS1, because it is an unique index on NAME field of TS$ table. But I think dropping that index is not wise .... or even acceptable.

Kari

--
(Mr.) Kari Pannila
Oracle DBA (OCP)
TietoEnator Corp - Telecom

Delete X to get a correct mail address ( X is only for the SPAMMERS ).
Received on Mon Apr 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US