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: DMT and LMT

Re: DMT and LMT

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Mon, 24 Mar 2003 13:07:30 +0100
Message-ID: <Pine.LNX.4.21.0303241301250.3800-100000@colargol.tihlde.org>

On Fri, 21 Mar 2003, Norman Dunbar wrote:

> Hi Hanne,
>
> your error 'ORA-12913 Cannot create dictionary managed tablespace' shows
> that you have a SYSTEM tablespace which is LMT and thus you are not
> allowed to have any other tablespaces which are DMT. 9i Release 2
> methinks !

Now, we have recreated our database, and evrything works fine. The DMT system tablespace worked well.

[..snipped a lot of import tips..]
> Trust me, doing it this way saves time on imports. If your import of a
> full dump file takes 10 hours then you could be importing 4 or 5
> different users when all you want is one.

Next time I will do it this way. Thanks!  

regards Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem
 
English is not my native tounge 
Received on Mon Mar 24 2003 - 06:07:30 CST

Original text of this message

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